Dude, 10 years later and you're still helping people. THANK YOU FOR THIS!
@Jojosmith3423 ай бұрын
all thumbs up to the BEST Excel teacher. Already subscribed from the 1st tutorial. Thanks Chester for sharing your knowledge 👍
@BigTymer00075 жыл бұрын
FOR THE LOVE OF GOD THANK YOU FOR SOLVING THIS. WHY DID EXCEL MAKE IT SO COMPLICATED
@xuxamelo4 ай бұрын
Hey! Thank you so much for this one. I completely forgot about Formula->Name Manager!
@TheMatrix00229 жыл бұрын
Chester this was an elegant and easy solution. Nicely explained. Thx for this.
@evmiengineering4828 Жыл бұрын
Thank you so much Sir. This really helped a lot!
@Michael_NL3 жыл бұрын
Great explanation, thank you so much. This really helped me out!
@saraghanaat23872 ай бұрын
Thank you You solved my problem🙏🏻
@peterbracuti25288 жыл бұрын
Excellent. Thanks. Was looking at trying to use tables in drop down lists and this explained it thoroughly.
@NithishKumar-uh4kn2 жыл бұрын
Excellent, Thanks
@markmckeon47643 жыл бұрын
"F3" in the List source is what I kept missing. Thank you!
@emiliesendra58395 жыл бұрын
Very useful - thank you!
@thomashopkins26418 жыл бұрын
very very helpful especially for beginners like myself
@vijay.khanna9 жыл бұрын
Thanks Chester, Brilliant solution. Have been looking for this for a while..
@steveulrich49365 жыл бұрын
thank you sir, this video was dead on exactly what I needed!!
@kennethogwo2 жыл бұрын
Fantastic. Thank you
@gavitou69323 жыл бұрын
Thanks so much for this!
@khalidQweder5 жыл бұрын
Great.
@Docker602 жыл бұрын
Brilliant tutorial, thank you...is there a way of adding multiple validations such as max text length to coexist with the drop-down list?
@robertkeuleers75405 жыл бұрын
Thanks Chester, a great help.
@kateelizabeth79384 жыл бұрын
Brilliant. Thanks, mate.
@notbrandechh5 жыл бұрын
Nice job. Thank you!
@parakramabahu5 жыл бұрын
this is awesome! thank you! Simple and elegant.
@CarlosMoreno-vw4ir5 жыл бұрын
Save me hours of work!!! Thanks so much!!
@xmen2pondy8 жыл бұрын
Thanks for the video. have been looking for this....
@Rincon00910 жыл бұрын
Thank you for making this video! Helped me out tremendously!
@RobertLongM4 жыл бұрын
GENIUS!
@Heshrodum8910 жыл бұрын
Thank you for the video. Very cool!
@Fruition108 жыл бұрын
So helpful! Thank you!!
@muralikrishnavn30389 жыл бұрын
Thanks ! Served my purpose. Well explained.
@gregoryk67023 жыл бұрын
Nice video, however since I started using data validation with this method in Sharepoint, it causes data loss error, and simply deleting the validation from the sheet.
@eugemaifa2 жыл бұрын
THANK YOUUUU omg.
@20shahla8 жыл бұрын
Thank you so much, great video !!!
@JPStones10 жыл бұрын
thanks. Just what I needed
@ADITIGUPTA-yy5dl3 жыл бұрын
can you please let me know what is the key used for pasting names during data validation
@thereviewshonor24545 жыл бұрын
I was looking for a tutorial on SHOW TABLE AS WE CLICK ON THE CELL. Like interactive way of recording data
@alvarochrispim33259 жыл бұрын
Hi Chester, I need to have an Excel with drop down list but I can not decide how many lines it will have. I mean, what I need is whenever I select the items from a drop down list in one line, immediately, the same drop down list items goes to the next line and so on.
@johnywhy46798 жыл бұрын
Great stuff, but why not just use a name, and not use a table object? Besides benefit of Table will auto-expand when you add a new item, what other advantage to using Table?
@maneeshagunawardena10439 жыл бұрын
thank you very much...
@erictsang81005 жыл бұрын
dear Chester how can i make the dynamic range vertically, Column wise In your case, department , country ..to grow the list to the right handsize
@kennethcarter43069 жыл бұрын
what about row 3 on the database table does that inherit the drop downs or do we need to do something extra?
@jesseblattstein85749 жыл бұрын
Wonder if you could help with something. Is there a way to record a macro that pulls variable data (different text each day) from a certain cell and then go inside a table with filters and choose the pulled data from the checkboxes inside the table and return the pertinent info? Thanks.
@Jeffa1705 Жыл бұрын
How do you do this in excel 2011 for Mac
@mhashim1233 жыл бұрын
Hi Chester. I followed your video and all is ok except I couldn't activate the VB pop-up alert. When I open my Excel workbook I get error msg "Runtime error (130. Type mismatch" I clicked debug button and I see in my VB workbook a n arrow with yellow text pointing to : If Date >= DueDate Then . Note that I have deleted any reference to Bring Forward Reminder (days) column H2 as I am not using it. I deleted all gaps between Date >=DueDate and the yellow fill disappears and saved it. But when I reopen my workbook the same format If Date >= DueDate Then appear. Can you help me resolve this issue. Let me know if you have an email contact for me to send my Excel workbook for you to review. Thanks in advance for your help.
@DavidHuff4me4 жыл бұрын
Much easier to just use =INDIRECT("Table[column]") as the data validation formula, then no need to doulbe ranges on top of tables...
@jigneshwaghela07110 жыл бұрын
Thank you !!
@ankitverma11810 жыл бұрын
how to make formula drop down in range
@anca01279 жыл бұрын
If I try to subtract/delete some values from the table, instead of updating the drop down list, I receive some blank spaces. What can I apply in order to have a refreshed table?
@rickpowell63248 жыл бұрын
Ahh, but what happens when duplicate Names are added. How can we limit the DataValidation dropdown to only Unique values?
@krish67276 жыл бұрын
Even confused
@UU-ry6gt8 жыл бұрын
how about to use =indirect ("tableName[columnName]")
@dovid69043 жыл бұрын
This doesn't work excel 2016
@colingass73136 жыл бұрын
Confused when u need to use the database idea
@AndyBritanny9 жыл бұрын
So creating a table can be done to make a dynamic range? And no offset formula is necessary? Wow
@himanshudesai71316 жыл бұрын
Please improve your speaking skills, & be clear on main point.