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.

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.

"Darren" wrote:

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.

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?

"bj" wrote:

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.

"Darren" wrote:

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.