+ Reply to Thread
Results 1 to 4 of 4

multiple data type validation

  1. #1
    Registered User
    Join Date
    12-01-2006
    Posts
    31

    multiple data type validation

    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

  2. #2
    Registered User
    Join Date
    12-01-2006
    Posts
    31
    difficult one i guess huh? :-(

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You can only have one validation rule in a cell.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: multiple data type validation

    No 100% fit but in the right direction I hope:

    Name List contains the following:
    Free
    Reserved
    Faulty
    0002????
    2004????
    2005????
    2007????

    Note The 000 before 2???? to make it working. I hope you can live with that.

    Validation Custion function of cell C13:
    =IF(ISNA(LOOKUP(2;SEARCH(List;LEFT(C13;8))));0;1)

    Gr,
    Ricardo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. blocking entries with data validation
    By jcavigli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2008, 05:00 AM
  2. Clear data in cells with validation
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-25-2008, 10:25 AM
  3. How can I speed up this slow macro?
    By rs2k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2008, 08:34 PM
  4. Data validation won't clear
    By rgarber1950 in forum Excel General
    Replies: 2
    Last Post: 11-06-2007, 02:38 PM
  5. How to paste into a Data validation list?
    By evillen2 in forum Excel General
    Replies: 3
    Last Post: 04-05-2007, 11:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1