My goodness, an true excel wizard. Would of never thought I would find a solution to the changing formula problem. THANK YOU
@Md.RiadMorshedChowdhuryКүн бұрын
Thank you so much for making this video. Your tutorial helped me a lot to save my time. Thanks
@h2e12 сағат бұрын
Glad it helped!
@johnboffin4766 ай бұрын
Mate, I wish you happy times, you are just great.
@melymel812 жыл бұрын
The OFFSET formula was great! Thank you!
@dennisheaddock6124 Жыл бұрын
The OFFSET function was very useful to me...TY :D
@peterjames4300 Жыл бұрын
Simple and concise Thank you
@imBipul Жыл бұрын
Thank you very much. It solved my problem. I stucked here for so long. (rows minus idea)
@morjes1522 жыл бұрын
I had to sign in just to like and comment in this video. That worked. Thank you so much sir! Have a nice day!
@FrankzunnebergNl2 жыл бұрын
Great Job, the first clear explanantion! Thanks!
@demetzosmanos3 жыл бұрын
YOU ARE DA BEST! Very clever way. Thank you so much!
@cemalkarabel60976 ай бұрын
thanks man, very helpful
@ryukoros2 жыл бұрын
Is there a way to make the dropdown list to be searchable?
@muhammedeldeeb2 жыл бұрын
Thanks a lot for your great video, it is very helpful
@joaoaraujo93693 жыл бұрын
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
@h2e3 жыл бұрын
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
@АртурСартания-и7о2 жыл бұрын
Great tutorial
@bunlong5372 жыл бұрын
thanks you for hide blank in validation ❤️️
@kevinsoon47842 жыл бұрын
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
@sai40953 жыл бұрын
Thank u so much!
@misssomod1942 жыл бұрын
Thank you
@ohhi63443 жыл бұрын
Thx :)
@mithunjo3 жыл бұрын
The table method didn't work for me. It didnt automatically update my list! What am I doing wrong?
@h2e3 жыл бұрын
make sure that in the source you use the = sign when referencing the range.