Finding Unique Records

[sam]

Hi, does anyone know how I can find unique records in a column in an
excel spreadsheet.

For example I have a spreadsheet with 5 colums and in column D I have
a list of names. Some of these names appear only once and some appear
more than once. What I would like to do is filter the name column (D)
to only display those records and their associated columns A, D, C, D,
E when the name in column D only appears once.

This will give me a list of customers who only have one entry on the
spreadsheet - is this possible?

Thanks in adbacne for your help

David

 

[Gord Dibben]

Have a look here for instructions.

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


Gord Dibben MS Excel MVP