david brown
New Member
- Joined
- Dec 15, 2002
- Messages
- 19
i have a list of numbers, which should all be one of 12 possible "codes".
What is the easy way to check that the numbers are correct and highlight any that are incorrect entries.
I could use a large if function, =if(a1="123456", if(a1="7891011"........,"ok", "false")...... but this seams very clumbersome.
is there a way to use =IF( A1= any value of this array,"true","Fales"
any help apreciated.
What is the easy way to check that the numbers are correct and highlight any that are incorrect entries.
I could use a large if function, =if(a1="123456", if(a1="7891011"........,"ok", "false")...... but this seams very clumbersome.
is there a way to use =IF( A1= any value of this array,"true","Fales"
any help apreciated.