i got a list of numbers
"1,4,7,10,13,16,19,22,25,28,31"
If i hit the value above in for example A2 i want it to return True if not then false.
What i can't figure out is to add multi values into a statement where just 1 single needs to be true to return TRUE
they are all in the same colonm and ive tried K2:K11 and K:K doesn't look like excel sees it as a value
[When i do 1-12 /13-24 / 25-36 i just basically do " =AND(1<A2; A2<12) " " =AND(12<A2; A2<25) " "=AND(24<A2; A2<37)" that works. But i don't have > or < in this case
Would be a great help if you could give me the solution
Kind regards
Jakup
Bookmarks