OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   General Discussion (http://www.officefrustration.com/forumdisplay.php?f=10)
-   -   Unique Values, not Unique Records (http://www.officefrustration.com/showthread.php?t=1114283)

steph44haf May 12th, 2010 04:38 PM

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?

Bob Umlas, Excel MVP May 12th, 2010 07:52 PM

Unique Values, not Unique Records
 
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?



All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
OfficeFrustration.com