Unique Values, not Unique Records

  • Thread starter Thread starter steph44haf
  • Start date Start date
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?
 
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

Create list based on data table 1
Help! Is this possible 2
Combining duplicate rows into one 2
Combining duplicate columns into one row 1
Finding Unique records 3
KEEP duplicate records 3
index/match, based on more than one criteria 2
Stumped: Find first match in list then reference dif cell in row.. 4

Back
Top