Autocomplete Drop-Down List - Google Sheets

[@MyDearFriend]

dude how do you not have more views or subs. your channel is awesome. thanks for the great tips

[@JeanBrnl]

that last trick is really great! Thanks !

[@muhammadnurhakimmohdderis4201]

The solution really impressed me... Not even see that coming

[@gregoryunderwood4121]

OH, Cleaver!! ❤️ You're brilliant!! Thank you!!

[@08HA28]

This Is very helpful , i have been trying to organize something like this for hours thank you very much ,

[@sunblock8717]

AAAAH! Thank you! This is going to save me so much time!

[@akshaykulkarni5626]

Wow... Great work.. Love your videos.. 😃 🔥🔥💯💯💯

[@peterlaszlo9611]

Really helpful. Thanks again for your videos, keep up the good work.

[@garychadwick1240]

Excellent thanks. I’ll definitely use that technique! 👌🏻

[@kehdi22]

Great video. I am a new follower.

[@ExcelGoogleSheets]

👍

[@jonastavernier7345]

Great solution. I have one additional question: Once you clear the data input in My List - Product columns, the list in Options is emptied as well. Is there a way to keep all the input in Options, regardless what happen in My List?

[@l.ballenger3821]

I am wondering this as well. Did you ever find an answer?

[@l.ballenger3821]

I am wondering this as well. Did you ever find an answer?

[@veevee7555]

Great 👍 sir thanks 🙏🙏🙏

[@cheewurz]

Cool Beans, Teacher!!!

[@sathyanarayanansatagopan9069]

Thank You, Very Much!

[@sunthoo]

Thank you. I learnt a new thing today. However, I was searching for tutorials make dropdown list so that when we select an option, the text on the next cell should change. I wanted to show the meaning of validation items.

[@Davion474]

This is a very neat trick lol.

[@lseh]

How do I do this but also have the columns to the right auto fill with additional data that is tied to the item from the drop-down?

[@viorelculea7753]

Super

[@johnaffolder5605]

Excellent video. Thank you. Will you do a video showing how to auto fill only one cell that is to the right of the drop down with a number. When choosing a selection in the drop down it will fill the cell with only a number that corresponds to that selection. I need to be able to select a certain city in the drop down and then it auto fill the other cell with the mileage only. Once this is done, will this create a problem to sum the miles at the bottom?

[@ExcelGoogleSheets]

kzbin.infosearch?query=dependent%20list%20google%20sheets

[@olasunkanmiadebero1132]

Freaking Fanstatic. I Love it

[@database_srg4120]

can this work on offline documents? I'm thinking of implementing this as a template for our clients, but internet connection can be a concern.

[@អនុវិទ្យាល័យបឹងនិមល]

sir google sheets can run script to search website in google or not?

[@AdhuPTY]

Hi. When we enter the first three letters of the data and the drop down list contains only one value matching it, then is it possible to press tab key to complete the data from the drop down list ? Apologies for my bad English

[@rccabral]

Hi! Im trying to automate a dayly save of a cell to do a grafh, do you have a video about that?

[@basharodeh5511]

Can you please explain how to establish an expanding quotation sheet based on a costing tab as you enter a new item in costing sheet where the quotation tab expand automatically to product a ready to print or send as pdf quotation??

[@ajaykumar-jj9bf]

You can use unique function for this method

[@ABC-ow5zs]

Hi, do you know how to automatically formulas in google form input in spreadsheet? Example the input form from google form always make new colum(like insert colum) that's why my formulas didn't work. Can you help me sir. Thank you so much!

[@uppukaram.]

thank you

[@archertalisic4734]

can we do this feature in Google forms ?

[@mdmazharulislam9564]

Thanks

[@andrey.skripnik]

THANK YOU

[@ExcelGoogleSheets]

:)

[@bogdans9374]

It's f*ing genius!

[@ExcelGoogleSheets]

:)

[@MK-jn9uu]

Genius

[@ljohnso16]

What if i want My List in a different document? any ideas how to modify?

[@adityaneve3482]

Thanku

[@kashanuddinzaighamkhan3511]

Is this possible for Google Forms? I'm stuck and can't find any solution. My plan is to populate a drop down using a google sheet. And then when user fills the form and starts typing, the matching options are filtered in the dropdown list. Thanks.

[@ExcelGoogleSheets]

No. You can use a Web App instead to do this but it's not easy to build. I've done something similar in these series kzbin.info/aero/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l

[@StephanErasmus0103]

Awesome! But how do you delete duplicates on the options tab?

[@yhavin]

You could use the UNIQUE function, but I'm pretty sure the dropdown list will only show each option one time regardless. Correct me if I'm wrong on that.

[@ExcelGoogleSheets]

You don't need to. Dropdown list only shows unique options.

[@vinodvishwakarma5387]

Where the cursor is, the column and row are highlighted. Please make such a video.

[@ExcelGoogleSheets]

This will be extremely slow in Google Sheets to the point that it will not be usable. Maybe once script executions get improved with added local support this will be useful.

[@saikat_is_here]

skip to 05:48

[@ariezsantos1072]

on this method how to avoid duplicate?

[@ExcelGoogleSheets]

Avoid duplicate where? Within dropdown there will be no duplicates anyway.

[@raulbezerra1929]

Ninja

[@heterozombie]

Do you also host the Get __it Done! channel? Somehow you've usually got a video for what I want to do.

[@ExcelGoogleSheets]

Yes.