+ Reply to Thread
Results 1 to 10 of 10

Data Validation One Dependent

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    St Petersburg, FL
    MS-Off Ver
    Office 07
    Posts
    37

    Data Validation One Dependent

    I have 2 in instances were there is only one dependent, is there a way to only have one dependent in a list?

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Data Validation One Dependent

    Do you mean you want to use Data Validation to only permit one specific value to be entered?

    If so, then in validation criteria choose:
    Allow: "List"
    Source: enter your permitted value
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    09-08-2014
    Location
    St Petersburg, FL
    MS-Off Ver
    Office 07
    Posts
    37

    Re: Data Validation One Dependent

    No, this is a follow up question from my previous thread on Data Validation. I have been successfully in creating the dependent data validation when I have more than one item in my list but if I only have one dependent I cannot create a list.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Data Validation One Dependent

    I have no idea what you're talking about.

    Explain your requirement assuming we have no knowledge of your previous threads. Make it completely clear what you are trying to achieve, what you have tried so far, what your problem is, and what your required outcome looks like. Attach a sample workbook if it would help.

  5. #5
    Registered User
    Join Date
    09-08-2014
    Location
    St Petersburg, FL
    MS-Off Ver
    Office 07
    Posts
    37

    Re: Data Validation One Dependent

    Nevermind, sorry to bother you. I will mark this solved an I appreciate your feedback.

  6. #6
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Data Validation One Dependent

    Did you resolve your issue?!

    If not - forget about 'bothering us', let's get it working. We only have what you type in a thread to work with, though, so you need to make it as clear as you can exactly what your issue is!


  7. #7
    Registered User
    Join Date
    09-08-2014
    Location
    St Petersburg, FL
    MS-Off Ver
    Office 07
    Posts
    37

    Re: Data Validation One Dependent

    I am working on it from a link (Con-textures) I was provided earlier. The problem is not having one dependent, the problem is I was trying to
    use the steps for the second data validation for a third validation. Once I finish I will let you know if I was successful.

  8. #8
    Registered User
    Join Date
    09-08-2014
    Location
    St Petersburg, FL
    MS-Off Ver
    Office 07
    Posts
    37

    Re: Data Validation One Dependent

    I am trying to add a third dependent data validation. Still stuck.
    Attached Files Attached Files
    Last edited by lornaerland; 09-10-2014 at 04:52 PM.

  9. #9
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Data Validation One Dependent

    What are you trying to achieve? For dependent validation, you need named ranges which match the values of the 'parent' list.

    So, for a validation list to change depending on which product you have chose, you need named ranges "Soft Sphere", "Soft Classic Sphere", "Soft Toric", then the data validation list formula should be, for example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I've added a couple of examples to your workbook (see attached) - changed cells highlighted yellow, and look at the extra named ranges I have added. You haven't stated any of your actual requirements, so the business logic won't make sense... but you should be able to see how the named ranges need to work, and the data validation references.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    09-08-2014
    Location
    St Petersburg, FL
    MS-Off Ver
    Office 07
    Posts
    37

    Re: Data Validation One Dependent

    It's not working, I am trying to add a third data validation list that based on the selections on cell C8 and L8 it will give
    the following:

    3rd Data Validation Lists

    PolyLensDesign
    Single Vision
    Multifocal
    Toric

    MethLensDesign
    PrismBallast
    Single Vision
    Multifocal


    HioxiLensDesign
    Toric

+ 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. Dependent Data Validation Help
    By MeCe in forum Excel General
    Replies: 4
    Last Post: 06-17-2014, 12:19 PM
  2. [SOLVED] Dependent dropdown validation - dependent data is string
    By jnewby in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 07:50 PM
  3. Dependent Data Validation If Not
    By ebdmbfan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2012, 12:58 PM
  4. [SOLVED] Dependent Data Validation
    By ricky82 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2012, 12:00 AM
  5. [SOLVED] Data Validation Dependent on Other Validation
    By CKRebel in forum Excel General
    Replies: 6
    Last Post: 07-11-2012, 10:41 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