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