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...
=SUMPRODUCT(0+(B$2:B$11=D2),1/COUNTIFS(A$2:A$11,A$2:A$11&"",B$2:B$11,B$2:B$11&""))
=SUM(IF(FREQUENCY(IF(B$2:B$11=D2,MATCH(A$2:A$11&"",A$2:A$11&"",0)),ROW(A$2:A$11)-MIN(ROW(A$2:A$11))+1),1))
Both of these will handle blank cells within the range A2:B11.
Regards
Would I be able to do the same for the below based on location?
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 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