Forum Discussion
EXCEL FORMULA HELP
Hello, I am trying to count headcount but cant seem to count unique values. example: Below is the text that i need a countif headcount and i cant seem to get unique values. If there are dupli...
Hello thats the thing i cant figure out.
I know in the example below that there are 3 Hourly in 1033 based on the individual names
that there are 3 hourly in 1012 based on the individual names.
Does that help?
| Name | Hourly | Location | Total Number of | |
| hursh | Hourly | 1033 | Hourly | ? |
| hursh | Hourly | 1033 | Salaried | ? |
| peanut | Hourly | 1011 | ||
| Kevin | Hourly | 1012 | ||
| Alex | Hourly | 1013 | ||
| Henr | Hourly | 1013 | ||
| Alex | Salaried | 1012 | ||
| peanut | Hourly | 1011 | ||
| hursh | Hourly | 1013 | ||
| Henr | Hourly | 1012 |
If you don't know then I certainly don't!
You mean to say that you can't tell us your manually calculated expected results for that dataset? Happy to provide you with the formula, but the logic behind that formula has to come from you.
Regards