View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
gjcase
 
Posts: n/a
Default Eliminate Duplicates in Pivot Table


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 "Unique records only."

This will produce a list of unique combinations of Item & PO.

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

would filter down to

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

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=507770