J
John McGhie
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...
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...