COUNTA(UNIQUE.....HOW TO EXCLUDE ROWS WITH "YTD" IN THE TEXT STRING

[JuicyMusic]

Well, you would think I would have no problem adjusting this simple formula to count unique entries in a column BUT exclude counting any row with the word YTD in it.

Here is my original formula :

=COUNTA(UNIQUE(A7:A637))

Here is how I adjusted my original formula to excluding counting any row with the word "YTD" in the text string:

=COUNTA(UNIQUE(A7:A637,"<>*YTD"))

I get a ONE as a result.

Thank you for your help in advance,
Juicy

 

[Eric W]

Try:

=ROWS(UNIQUE(FILTER(A7:A637,ISERROR(SEARCH("YTD",A7:A637)))))

 

[JuicyMusic]

I actually had inserted the FILTER function but didn't know how to finish it. SEARCH!!! Thank you so much SOLVED

 

[Eric W]

Happy to help! ?