JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
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 :
Here is how I adjusted my original formula to excluding counting any row with the word "YTD" in the text string:
I get a ONE as a result.
Thank you for your help in advance,
Juicy
Here is my original formula :
Excel 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:
Excel Formula:
=COUNTA(UNIQUE(A7:A637,"<>*YTD"))
Thank you for your help in advance,
Juicy