Apr 05 2020 06:54 PM
How to Count Unique Text Values in a Range with multiple criteria (more than 3 to be precise) in Excel
Apr 05 2020 07:12 PM
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.
Apr 05 2020 08:03 PM
Can I add 3 criteria? @Faraz Shaikh
Apr 05 2020 08:22 PM
Apr 05 2020 08:51 PM
Please see attached file@Faraz Shaikh