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

Hi

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

Roger Govier


"Freshman" wrote in message
...
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

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

"Roger Govier" wrote:

Hi

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

Roger Govier


"Freshman" wrote in message
...
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