Hi gurus.
I am trying to sort out a validation rule which will allow users to enter certain values into column A. However, the difficult bit is that the values can be a set of numeric OR text strings. I'll elaborate:
The text entries that will be permitted are:
Faulty
Free
Reserved
The numeric strings permitted should be of the following formats only (here's the tricky one). The X's shown below are ofcourse representing any number from 0 to 9.
2xxxx
2004xxxx
2005xxxx
2007xxxx
I hope this will be enough for some1 to help out.
Really appreciate everyone's time!
thanks
Bookmarks