Duplicate, Duplicate, dupli ...

[Dave Corbett]

Hi,
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
..
Thanks.
Dave

 

[Gord Dibben]

Dave

Data>Filter>Advanced Filter. "unique records only" and "copy to another
location"

For more on this visit Debra Dalgleish at

http://www.contextures.on.ca/xladvfilter01.html

Gord Dibben Excel MVP

 

[Judy Freed]

Data, Filter, Advanced Filter, Unique REcords Only.
More info here:

http://www.uncc.edu/sysdev/howtos/excel/advanced filtering.htm


Hope this helps!

Judy Freed
Systems Development
UNC Charlotte