Forum Discussion
Count unique values including specific character
Hi, please help... Which formula can I use to create the numbers in yellow? From column A I would like to count the unique values containing a "P" Thank you already for helping!
In D3:
=COUNTA(UNIQUE(FILTER(A2:A18, ISNUMBER(SEARCH("P", A2:A18)))))
In D4:
=COUNTA(UNIQUE(FILTER(A2:A18, ISERROR(SEARCH("P", A2:A18)))))
- Thanks!
