data validation (multiple options)
Hi Matt,
Not a pretty solution but data validation will accept a list - obv
this means a big list in this case.
Cheers,
JF
On 24 Sep, 13:13, MJKelly wrote:
Hi,
I have range which requires validating, but the allowed inputs are
whole numbers 1 to 2000 and "SL", "AL", "UA" and more.
Can validation cater for this? *I don't want to write code to check
the input unless there's no other way.
Kind regards,
Matt
|