Create an Excel Drop Down List Without Blanks

[@virtualveins2351]

My goodness, an true excel wizard. Would of never thought I would find a solution to the changing formula problem. THANK YOU

[@johnboffin476]

Mate, I wish you happy times, you are just great.

[@melymel81]

The OFFSET formula was great! Thank you!

[@dennisheaddock6124]

The OFFSET function was very useful to me...TY :D

[@morjes152]

I had to sign in just to like and comment in this video. That worked. Thank you so much sir! Have a nice day!

[@FrankzunnebergNl]

Great Job, the first clear explanantion! Thanks!

[@peterjames4300]

Simple and concise Thank you

[@imBipul]

Thank you very much. It solved my problem. I stucked here for so long. (rows minus idea)

[@demetzosmanos]

YOU ARE DA BEST! Very clever way. Thank you so much!

[@cemalkarabel6097]

thanks man, very helpful

[@muhammedeldeeb]

Thanks a lot for your great video, it is very helpful

[@ryukoros]

Is there a way to make the dropdown list to be searchable?

[@user-jb5yb9iu2i]

Great tutorial

[@bunlong537]

thanks you for hide blank in validation ❤️️

[@joaoaraujo9369]

i tried the table metod and it works if it is on the same page, but if it inst when you add something more, it doens add to the drop down list

[@h2e]

If it's on another sheet, use the INDIRECT function. If your table name is Table1, use the following as the source:
=INDIRECT("Table1")

[@anciteleaenergiaeambiente7078]

@@h2e Hi, I'm having the same problem but the table isn't named and I'd prefer to keep it without. How can this be solved? I'm really wondering if all this complication has a purpose... why not just giving the option to have a data validation list that excludes blanks right away? Sounds like a very common need that people would have all the time. By the way sorry for the rant and thanks for your help

[@sai4095]

Thank u so much!

[@misssomod194]

Thank you

[@kevinsoon4784]

This didn't work for me too. Blanks are still showing up in the dropdown. Please kindly advise. Thanks!

[@edreeshliel160]

Sort your list from A to Z then the blank will be in the end... Then Use offset

[@ohhi6344]

Thx :)

[@mithunjo]

The table method didn't work for me. It didnt automatically update my list! What am I doing wrong?

[@h2e]

make sure that in the source you use the = sign when referencing the range.