Forum Discussion

Copper Contributor

Jun 04, 2020

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...

Formulas and Functions

office 365

hurshie

Copper Contributor

Jun 04, 2020

Jos_Woolley

THank you I was trying to use Countifs!

Jos_Woolley

Iron Contributor

Jun 04, 2020

Why? The set-up with COUNTIFS reciprocated by unity is much less efficient than the FREQUENCY/MATCH set-up, especially over large ranges.