software

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


Have you tried using an advanced filter for unique records only?

If items are in Col 1 and POs in col 2, you can select
Data/Filter/Advanced Filter, and specify a Copy To range. Be sure to
select quot;Unique records only.quot;

This will produce a list of unique combinations of Item amp; PO.

The following list:
ItemPO
1a
2b
3c
4a
5b
6c
1a
2c
3b
4a
5c
6b
1d
2e
3f
4d
5e
6f

would filter down to

Unique
ItemPO
1a
2b
3c
4a
5b
6c
2c
3b
5c
6b
1d
2e
3f
4d
5e
6f

---Glenn--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=507770
If u put PO Number in quot;rowquot; amp; also Item Number in Row, While date/month
in quot;columnquot; amp; Product/ Item(Count) in quot;dataquot;. u should get the total of
Item count per PO. It shows total of Item Per Po Number. But Can not
ignore on the ground of uniqueness. But no TWo or More Entries will be
shown of Item Per PO . I think this should solve your problem--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: www.excelforum.com/member.php...oamp;userid=30964
View this thread: www.excelforum.com/showthread...hreadid=507770