Forum Discussion

cesarmontesinos312

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

Formulas and Functions

4 Replies

ExcelExciting
MVP
Apr 06, 2020
Hi cesarmontesinos312

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.
- cesarmontesinos312
  Copper Contributor
  Apr 06, 2020
  Can I add 3 criteria? ExcelExciting
  - ExcelExciting
    MVP
    Apr 06, 2020
    Hi cesarmontesinos312
    
    Please attach the sample file with your desired result
    
    Regards, Faraz Shaikh

Resources