+ Reply to Thread
Results 1 to 4 of 4

Multiple Data Validation in one cell

Hybrid View

  1. #1
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Multiple Data Validation in one cell

    Perhaps you could take advantage of Data Validation's error checking features:

    Try this
    • Put your list of levels in a named range...I used: LU_Level
    • Select the cells to be impacted with the DV
    • CTRL+1....(to open the formatting window)
    ...Number_tab
    ...Category: Text
    ...Click:OK
    • Data.Data_Validation.Data_Validation
    ...Allow: List
    ...Source: LU_Levels
    ...Error_Alert_tab
    ...Style: Information
    ...UNcheck: Show error alert
    ...Click: OK

    Now...Each cell will display a dropdown list of the levels...BUT...you can also enter anything you want.
    If that works for you, we'll need to figure out how to summarize/average/whatever the resulting values.
    You may need to amend your list to something like:
    L -1
    L 1
    L 1+
    etc
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  2. #2
    Registered User
    Join Date
    12-04-2012
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Multiple Data Validation in one cell

    Levels and Numbers - Forum.xlsx

    Hi Ron,
    Thank you for the quick reply. I confess that I did not follow your instructions once I tried CTRL+1. This did open a formatting window, but the standard one (Number, Alignment, Font, etc). I am Excel 2010, but I don't think that is the issue.

    I am attaching a copy of a working version of the spreadsheet that I am trying to create. I hope that might help.

    Thank you.

    Mark

  3. #3
    Registered User
    Join Date
    12-04-2012
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Multiple Data Validation in one cell

    Hi Ron,

    My mistake - I misread one of your instructions. I have made the changes that you suggested.

    I am going to work through this to see how it goes.

    THANK YOU!

    Mark

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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