ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Tables Sum of Unique Text Entries (https://www.excelbanter.com/excel-worksheet-functions/63155-pivot-tables-sum-unique-text-entries.html)

Jen

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


All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com