Prev: Edit with Microsoft Query - Menu Option
Next: conditional formatting
From: steph44haf on 12 May 2010 11:38
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?
From: Bob Umlas, Excel MVP on 12 May 2010 14:52
in the dialog for the advanced filter, make sure only the ID column is
referenced

"steph44haf" wrote:

> 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?
 | 
Pages: 1
Prev: Edit with Microsoft Query - Menu Option
Next: conditional formatting