I have 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?

Ant help appreciated.

Thanks,

Mal