Sort names (first,last) into correct columns

[treva26]

I have 3 columns of names (first, middle and last) but each row is in a different order.

ie-

first last middle
last first middle
middle last first
last middle first
...

I have another list of names (on the 2nd sheet) in the correct order.

I need to rearrange the first list into the correct columns,
being careful of people with the same last names.

The second list is shorter as some people no longer work here, also the middle names are generally not known, they dont matter as much.

I know it may not be possible to sort them all out but how much can be done?

See the attached workbook.

[rylo]

Hi

See how this goes for a start.

Make sure you are on the Unordered Names sheet when you run it.

Please Login or Register  to view this content.

rylo

[treva26]

Yea, very nice.
Thanks.