View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Isabelga
 
Posts: n/a
Default Pivot Table- how do I eliminate duplicates in count of name

I have built a pivot table from a table containing a list of people.
My pivot table will count people based on the field Name.
Some people names might have several entries in the table but in this case,
I want the name to be counted a 1.
What is the appropriate set up for this ?
Thankk you for your help.