re: Data Validation: two conditions

From: John McGhie (john)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 00:09:01 -0700

Hi Mark:

I am not sure I understand you. If I set the validation to "Whole Number", how am I going to accept the State abbreviation at the front of the string?

Enquiring minds (in Sydney) wish to know :-)

Cheers 

-- 
John McGhie <john@mcghie.name>
MVP Microsoft Word and Word for Mac
"Mark" wrote:
> Gidday (from Melbourne),
> 
> Data Validation is only used if a number entered into the 
> range does not meet criteria set by you.
> 
> Also your range of numbers 1 to 999 does not leave any 
> room for anything else unless the number is less than 0 or 
> more than 1000.
> 
> In that case,
> Allow =Whole Number
> Minimum=1
> Maximum=999
> 
> When the user inputs a number say, 1.22 an alert comes up.
> if the number is negative or 1000+, also alert.
> 
> Does this help?
> regards
> Mark
> http://au.geocities.com/excelmarksway
> 
> 
> 
> 
> >-----Original Message-----
> >Hi All:
> >
> >Can someone please save me having to think? ...
> >
> >I need to validate entries in a column of cells which 
> must take the format of xxx999 where xxx must be one of 
> the following two or three character values: QLD, NSW, 
> VIC, TAS, SA, WA, NT; and 999 must be a value between 001 
> and 999.
> >
> >I'm struggling to understand what formula should go in 
> the Data Validation custom dialogue box.
> >
> >Can I do this with data validation?  If so, what is the 
> formula I use to validate the two components?  The state 
> abbreviation is easy: that's just a named list, right?
> >
> >NSW
> >NT
> >QLD
> >SA
> >TAS
> >VIC
> >WA
> >
> >It's validating that the concatenated digits to the right 
> are between 001 and 999 that has me stumped.
> >
> >Please advise...
> >
> >-- 
> >John McGhie <john@mcghie.name>
> >MVP Microsoft Word and Word for Mac
> >.
> >
>