ooops you wanted to NOT allow those characters, correct?
=COUNTIFS($J$13:$J$20,"*"&C4&"*")=0
ooops you wanted to NOT allow those characters, correct?
=COUNTIFS($J$13:$J$20,"*"&C4&"*")=0
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello fdibbins,
your formula works only with one character
with more than 1 character does not work.
=CONTA.PIŁ.SE($J$13:$J$20;"*"&C4&"*")=0
=COUNTIFS($J$13:$J$20,"*"&C4&"*")=0
max_max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks