Flow sequence

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Freshman - 14 Jun 2007 10:07 GMT

Dear experts,

I got an external table showing the flows of parcels. For example, column A
is for source locations and colum B is for destination locations.

Parcel 123 (for example)

From Shop To Shop

A1 B7
.
.
.
.
B7 C10
.
.
C10 D9

If there are more than 100 rows of source locations and I want to see the
flow of a parcel at one glance, such as:

Shop A1 --> Shop B7 --> Shop C10 --> Shop D9.

Is there a way to do it? Please kindly advise.

Thanks in advance

Reply to this Message

Roger Govier - 14 Jun 2007 10:35 GMT

Hi

You could use extra columns
In C2 enter
=IF(B2="","",IF(ISNA((VLOOKUP(B2,$A:$B,2,0)),"",VLOOKUP(B2,$A:$B,2,0)))
copy across to D2 (and E2??)
Copy all formulae down columns as far as required

Signature

Regards

Roger Govier

> Dear experts,
>
[quoted text clipped - 25 lines]
>
> Thanks in advance

Reply to this Message

Freshman - 14 Jun 2007 14:53 GMT

Hi Roger,

Thanks for your time and solution. It works but if the flow sequence is
long, how can I know which row is the 1st source location?

Please advise and thanks in advance.

Freshman

> Hi
>
[quoted text clipped - 32 lines]
> >
> > Thanks in advance

Reply to this Message