Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate Duplicates in Pivot Table
I have a large spreadsheet with, among other columns, a column for PO number
and another for item number. I need to determine the number of unique PO's for each item (just a count/quantity). If an item shows up twice on the same PO, it only gets counted once. I thought a pivot table might do the trick but don't see a setting for eliminating duplicates. Is there one? If not, what's a good way to get the information needed (i.e. 2 columns - one with the item number and the other with the number of unique PO's that contain that item number)? Any help would be appreciated. Thanks, Will |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table- how do I eliminate duplicates in count of name | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot table column duplicates | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) |