I have 2 in instances were there is only one dependent, is there a way to only have one dependent in a list?
I have 2 in instances were there is only one dependent, is there a way to only have one dependent in a list?
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...
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.
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.
Nevermind, sorry to bother you. I will mark this solved an I appreciate your feedback.
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!
![]()
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.
I am trying to add a third dependent data validation. Still stuck.
Last edited by lornaerland; 09-10-2014 at 04:52 PM.
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:![]()
=INDIRECT(SUBSTITUTE(D8," ",""))
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks