data validation (multiple options)

's Computer Specifications

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

's Computer Specifications

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 <matt.j.ke...@gmail.com> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Data Validation Options	willwonka	Microsoft Excel Misc	2	19th Mar 2010 05:10 PM
data Validation options	=?Utf-8?B?Sm9zaCBD?=	Microsoft Excel Worksheet Functions	2	16th May 2007 11:09 PM
Data Validation - Multiple Options	=?Utf-8?B?TFBT?=	Microsoft Excel Misc	8	11th Aug 2006 03:16 PM
data validation - select multiple options?	=?Utf-8?B?QS4=?=	Microsoft Excel Misc	3	2nd Jan 2006 09:13 PM
Data Validation - mixture of options	Jack Sheet	Microsoft Excel Misc	6	20th May 2005 03:54 PM