M
Mal
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
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