I have a SPREADSHEET I am working on.
1 column has 16,789 names. 2ND 2,000. With almost 17,000 names I cant do it manually
I need to cross reference the names that are in column 1 with the names in column 2.

So I need to line up the duplicate names between the two colums

Ex. The list looks like this
Column 1 \ Column 2

jane Doe \ Richard Doe
Marcus doe \ Mark Doe
Shane doe \ Jane Doe
John doe \ Patricia Doe
Mary Doe \ Marcus Doe
Patricia Doe \ Eric Doe



I need it to look this this

Column 1 \ Column 2

Jane Doe \ Jane Doe
Marcus Doe \ Marcus Doe
Patricia Doe \ Patricia Doe
Mary Doe \ Richard Doe
Shane Doe \ Eric Doe
John Doe \ Mark Doe


HELP!
  Has it really got all those people called Doe?
Please confirm this POINT.  Do you want to re-arrange the values in column 2 to that the 2,000 names in it are moved to the cell to the right of the corresponding cell in column 1?  In other words, column 2 would have blank rows between most names, while column 1 has no blank rows between names, right?

Does your version of OFFICE have Access, the database?  If so, I believe it would work better for what you're trying to do. Hi soybean,

As I understand you want to verify if the names in column is same as in another.

If you are using Microsoft Office, then follow the below procedure:
=IF(A2=B2,"Yes","No")

If you are using OPEN Office 3.2 then follow the below procedure:
=IF(A3=B3;"Yes";"No")
You can customize it according to your need and comfort.
This will display you "Yes" if the names are same and "No" if the names are different.

Hope this helps you.