View Single Post
  #1  
Old May 12th, 2010, 04:38 PM posted to microsoft.public.excel.misc
steph44haf
external usenet poster
 
Posts: 46
Default Unique Values, not Unique Records

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?