I am having a list of names in Excel 2003, Last Name in column A first name in B sorted in Alfa order.
I get a list from an external source that includes names that I wish to match to my list.The problem is that the format of the supplied list is completely different to my list and I cannot get the source to change their format.
e.g.
My List
A B
Black Bill
Brown J
Jones Amy
Smith John
White Sandra
The supplied list is in Excel in one column as follows and not sorted:
Amy Jones
B. Black
S J White
John J Smith
Joe Brown
The only constants are the Last Name and the punctuation and spaces vary. I was thinking of maybe somehow sorting backwards on the last name? Any help appreciated.
Bookmarks