Finding Unique Records

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Excel does not accept text format! 0
Mail Merge Help 1
Mail Merge Directory Conditional Page Break 0
Re-title multiple MS Project .mpp files at once 0
Extracting a cell value 2
Sharepoint not capturing staff name when automation runs 0
Autonumber field in Excel that behaves the same as Access 0

Top