View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Pivot Table Unique ref

Hi

The count will be relative to the Row Fields (and/or Column Fields).
i.e it will be a count of the data field that matches the Row/Column fields.

--
Regards
Roger Govier

"Bod" wrote in message
...
Do I need to put a field which contains unique identifiers for each record
into the Data Items (bottom right) bit of the pivot table?
I thought I did, but when I used a field that doesn't have unique records,
the count was still the same.