Sorting?

D

Darren

I have two columns one has a list of names; the second also has the same list
of names. Column one is not in ascending or descending order and the order
may not be changed. How can I get the names in the second column to match up
with it corresponding name in the first column.
 
B

bj

if the first column is column A and the second column column D
in Add column E and enter in E1
=match(D1,A:A,0)
this column will indicate the row that the Column A name is in
depending on what you want to do, you can sort if there is a one to one
cooerelation in the column data.
 
D

Darren

Thanks bj,

The match shows what line the matching word is on. some of the words dont
have matches so I get a #N/A which is fine.

Any ideas on how to get the matching words on the the corresponding line?
 
Top