Pivot Tables

[jackmark]

Dear Friends,

I have query in Pivot tables.
It is regarding removing of duplicate entries.

I have explained this in the attached zip file.
zip file contains .xls file.

Please help me out.

Jack

[VBA Noob]

Hi,

I've not looked at the pivot but think this link could help. Add a helper column with formula then add to pivot and filter

http://www.contextures.com/xlPivot07.html#Unique

VBA Noob