View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark R. Mark R. is offline
external usenet poster
 
Posts: 6
Default PivotTable Row Count

I have a PivotTable sorted into a list of Names, each associated with a set
of unique account numbers. I.e., the row area of the table is NameAccount
Number. This gives me the list of unique account numbers associated with
each name, but I can't find a way of totaling the number of unique numbers
per name. Using a "count of account numbers" in the Data field doesn't work,
as each account number may appear multiple times in the data that the pivot
table is based on. Any ideas/suggestions?

Thanks!