Excel Magic Trick #241: Data Validation w Shrinking List
Loading...
5,720
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (8)
-
Dear soulsaver04,
Yes, it takes a while to get the hang of array formulas, but once you do you have a new universe of Excel possibilities!
--excelisfun
-
oh yah i have to control shift enter
-
Dear cbaskis,
Not that I know. Not with tables set up as databases because the whole column would have formulas.
However, you could combine it with this video:
YTLE#75: DV Drop-Down based on DV Drop-Down
--excelisfun
-
I fat fingered it and figured it out.
Is there anyway to combine this with your video on the dynamic ranges, EMT#259?
Loading...
This is a real time saver!
just used it in my worksheet and it is working perfectly, real time saver.
Thank
6642633 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Thank you sir!
SanadFeisal 2 years ago
You are welcome! Thanks for the 5 star ratings for all the videso that you have been watching!!
ExcelIsFun 2 years ago
Can you tell me how I would change these formulas if I wanted to do drop down boxes in more than one column? You have drop down boxes for just column E. I need drop down boxes for 10 columns (columns E-N).
csm634s 2 years ago
It would be a lot to do with formulas, your best bet is to do it with VBA code. I am not good with VBA. Post a question to the Mr Excel Message Board and maybe you can get some help there.
ExcelIsFun 2 years ago