Conditional Data Validation

[@AAKASHKUMAR-sc3ps]

Nice one, i have literally viewed multiple videos for this

[@AbhayGadiya]

Thanks, there is one more coming soon on the same topic so stay tuned.

[@vinaysreerama3290]

Loved it. No nonsense and gets to the objective immediately. Have subscribed to your videos. Thank you

[@amyspringrose9231]

Amazing effective explanation, tks so much !

[@AbhayGadiya]

You are welcome!

[@runawaycloser]

Great video! Simple and easy to follow.

[@AbhayGadiya]

+Alexander Goulet Thank you

[@anjulasingh1563]

After a little practice I did it 😊😊.

[@mjawadmirza]

Smart & nice solution.

[@prof.prachikulkarni1764]

Why take long cut? Use indirect in the second data validation list source

[@AbhayGadiya]

Indirect is volatile function

[@PriyankSaraf-ej5cq]

thanks, very helpful

[@AbhayGadiya]

You're welcome!

[@leonvilfand2192]

I tried doing that on the latest excel office 365, but keep getting Warming: "You may mot use reference operators (such as unions, intersections, and ranges) or array constants for Data Validation criteria"

[@Goldenbootster811]

Doesn’t working as options are not consistent in drop down and coming as mix and match after 1st row..any idea ??

[@Coco_thenaughtylab]

Exactly the same happened with me

[@bhaskar3161]

Clearly explained! thanks!

[@guneetvlogs]

Formala is not pasted in data validation in last step.. please help

[@monikab.6540]

Amazing, thank you!

[@sagyshehata3616]

wow

[@excelisfun]

Cool!

[@AbhayGadiya]

Thanks.

[@Piangporn]

Thank you ka

[@vincent600]

It did not worked, dont know why,

[@amarpreetp]

Not working