+ Reply to Thread
Results 1 to 5 of 5

Help require data validation

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Help require data validation

    Hi friends,
    I want to restrict the data entry in range c5:c50. I used custom data validation for it using the formula
    Please Login or Register  to view this content.
    But no require output.

    How to use data validation to restrict the data entry as:
    Numbers between: 0:25
    Letters: Ab
    Letters: L

    In short user has to enter any value within this range and no other value is allowed in this range.

    Any help will be highly appreciated.

    Thanking you in anticipation.
    Sincerely,

    mso3

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Help require data validation

    Try this....

    Select C5:C50 --> Data Validation --> From Allow drop down select Custom --> In the formula box type the formula given below --> OK.

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    03-19-2013
    Location
    Cambridge, England
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Help require data validation

    Hi,

    I think what you need to do is select cell C5, go to data validation -> Custom -> formula and use:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then if you copy cell c5 all the way down to cell c50 the logic should change with it. So the data validation for C50 will be:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Note: this will accept, 0 to 25, AB, Ab, ab, aB, L and l. If uppercase and lowercase matter to you, feel free to ask for more help.

    Have fun!

  4. #4
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help require data validation

    Hi Sktneer,
    Glad to see you after a long time with a perfect solution. It's working absolutely fine as per my requirement.

    Hi Alex,
    The solution suggested by Sktneer is perfect because it didn't allow any value exact than the requirement including upper/lower case.
    No matter yours is also fine.

    Thank you to both of you for your kind perfect solution.

    Have a nice time.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Help require data validation

    Glad I was able to help.

+ 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. Require VBA code to Get data from data table to user form using command button
    By Srikanth H N in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2014, 04:17 PM
  2. [SOLVED] Require Help - Require Formula for Multiple values in both columns
    By krodge in forum Excel General
    Replies: 6
    Last Post: 01-13-2012, 03:42 AM
  3. Help require to manage data.
    By noodle in forum Excel General
    Replies: 6
    Last Post: 09-30-2009, 04:49 AM
  4. [SOLVED] data validation- Does this require coding a macro from scratch?
    By sherwinb in forum Excel General
    Replies: 1
    Last Post: 02-01-2006, 06:10 PM
  5. QUERY ABOUT DATA REQUIRE
    By RASHESH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2005, 12:06 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