Unique Values, not Unique Records

S

steph44haf

My data looks like the following:

ID Type Amt
1234 A $10.00
1234 B $10.00
1234 C $10.00

I would like to find a way to get only one of the items on to a new
spreadsheet, because they are duplicate records in my eyes. The Advanced
filter does not work because each record is unique. Can anyone help?
 
B

Bob Umlas, Excel MVP

in the dialog for the advanced filter, make sure only the ID column is
referenced
 

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

Combining duplicate rows into one 2
Combining duplicate columns into one row 1
Help! Is this possible 2
KEEP duplicate records 3
unique records by advanced filter 10
Stumped: Find first match in list then reference dif cell in row.. 4
Sum and count of unique values 4
Filtering for Unique Records 3

Top