Excel Magic Trick #241: Data Validation w Shrinking List

[6642633]

This is a real time saver!

just used it in my worksheet and it is working perfectly, real time saver.

Thank



[ExcelIsFun]

You are welcome!

[SanadFeisal]

Thank you sir!

[ExcelIsFun]

You are welcome! Thanks for the 5 star ratings for all the videso that you have been watching!!

[csm634s]

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).

[ExcelIsFun]

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.

[soulsaver04]

oh yah i have to control shift enter

[ExcelIsFun]

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

[cbaskis]

Your videos are far better than any excel book I have seen this far. Thanks!

On the items used list, my values will not populate unless I go in order. w1, w2, w3..fine...skip to w5, will not populate. Thoughts? Thanks again.

[ExcelIsFun]

Dear cbaskis,

I am glad that the videos are useful!

I don't know what is causing the problem with your formula without seeing it. Did you download the workbooks I provide? I have a starting workbook with the template that you can fill out and I have a finished workbook with the finished formula. Then you could compare your formula. Not Only That, but the workbooks have lots of notes and reference visoes if you are interested in the topic.

You could post your formula here also.

--excelisfun

[cbaskis]

I fat fingered it and figured it out.

Is there anyway to combine this with your video on the dynamic ranges, EMT#259?

[ExcelIsFun]

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