Hey guys, i'm new here and need some Excel help.

Using Office 2003.

I've got a long list of names (we'lll call it List A) with separate columns for various data like SSN and geographic location, etc. I've got another list (List B) of names which I'm trying to compare it to. Ultimately I want to come up with one MERGED final list but obviously I want to avoid having any duplicate entries.

The problem is further excerbated by List A being sorted in alphabetical order by last name, first name. List B is sorted by first name, last name. This obviously makes the comparison task very tough. Is there a way to modify list B so that it's sorted by last name (just like list A)?

Is there any way out of this nightmare?