Multiple Validation Criteria

[RDC100]

Good Morning,

Using Excel 2000 I am trying to create a register to aid configuration management.

Column B will contain unique IDs, alphanumeric and four characters long.

I wish to restrict the input format to unique entries only, four characters in length and also upper-case if possible.

I think I have found the appropriate formulas but have no idea how to use multiple validation criteria together (fairly inexperienced with Excel).

I've got as far as preventing duplicate entries using 'custom' data validation:

Is there a way to add additional validation criteria?

I.e. =LEN(B5)<=4 ?

Many thanks,

Rob.

 

[Sandeep Warrier]

Hi & welcome to the Board!

You can try this as the validation criteria:

=AND(COUNTIF($B$1:B1,B1)=1,LEN(B1)=4)

If you also want to check for alphanumeric characters, I think you'll need to use VBA.

 

[RDC100]

Thank you Sandeep, that worked like a charm!