help - eliminating dupes in Excel

[mrbigstuff]

I have a large address list (10k names with addresses). I need to cull the dupes in order the goal is to arrive at a list with only unique addresses. The info attached to these addresses is not important in determining the file (i.e., the names of the residents), but I do need to figure out a way to make certain that I keep the unique identifier of the second address line, the apartment #.

e.g.:

address/ apt/ last/ first

12 new road, smith, bob
12 new road, smith, jane
12 2 new road, jones, jane

I want to keep the unique addresses, don't care about the names. (either #1 or #2 AND #3)

Thanks

[Craig]

How are the data separated in excel? Do street number, apt number, street name, etc. each have a separate column or is the entire address contained in one cell?


Craig

[mrbigstuff]

Yes, they do all have separate columns. There are 3 columns for the #, one for the street name and then other columns for names of persons, etc.