I have a excel document with several different numbers in column A, when i pivot the data and 'Count' this value it totals these values. I want it to only show this figure once
e.g
Number Name 123 Joe 123 Joe 234 Mark 234 Mark 234 Mark 999 Jackie 567 Anne
So i want to pivot table to show
Joe - 1
Mark - 1
Jackie - 1
Anne - 1
At the moment its showing
Joe - 2
Mark - 3
Jackie - 1
Anne - 1
Can any body help me???
Bookmarks