Hi all,
I need a formula for a selection of cells in one column that DO NOT contain the word "sheet".
So, COUNTIF A5:A144 does not contain "sheet".
Anyone that can help me with this?
Thank you in advance
Hi all,
I need a formula for a selection of cells in one column that DO NOT contain the word "sheet".
So, COUNTIF A5:A144 does not contain "sheet".
Anyone that can help me with this?
Thank you in advance
How about:
=COUNTIF(A5:A144,"<>*sheet*")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ali, that did it! Thank you! I had my parentheses in the wrong place so you helped. THANK YOU!!!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks