want to see if a range doesn't contains any values other than this

[banneduser123]

hi,

can't figure this out.

I want to create a formula that will check all of column A, to see if it contains any values other than "October".

So here's an example:

Column A
October
October
March
October
April


In the example above, the formula should return ether "Yes" or "No". That doesn't matter, i just don't know how to write a formula that says if this range contains any values other than "October", then tell me "Yes".


hope that was clear..

 

[Peter_SSs]

Glad you got it sorted.