Finding Unique Records

  • Thread starter Thread starter sam
  • Start date Start date
S

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
 
Back
Top