Forum Discussion

Copper Contributor

Apr 06, 2020

Count Unique Text Values in a Range with multiple criteria

How to Count Unique Text Values in a Range with multiple criteria (more than 3 to be precise) in Excel

MVP

Apr 06, 2020

You can use the function

=COUNTA(UNIQUE(Range))

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.