View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen
 
Posts: n/a
Default Pivot Tables Sum of Unique Text Entries

I am working on a pivot table that I need to indicate # of employees per
status of active or termed. Within the range there may be multiple entries
for one individual how would I get a count of employees by status
Example of current Pivot:

Emp Status Status Bus Unit Site Total(this would
be 3 of emps)
A Dist D. Sales Denver 0