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

JMB17

Bronze Contributor

Jun 04, 2020

=sumproduct(1/countif(a1:a10,a1:a10&""))

if you want to exclude blank cells
=sumproduct((a1:a10<>"")/countif(a1:a10,a1:a10&""))