Create a Google Sheets row of dropdown menus selected in any direction with diminishing choices

Have you ever wanted to create a row of dropdown menus all with the same set of choices where a user can select as many options in the row and after each selection the options only contain the remaining choices? Then this tutorial is for you. Check out the written tutorial here: https://yagisanatode.com/2021/07/04/update-a-range-of-dropdown-lists-in-a-google-sheet-dynamically-based-on-a-previous-dropdown-choice/#Bonus_2_-_Any_dropdown_in_a_row_with_display_remaining_dropdown_options

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/...

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections... #GoogleSheets #Spreadsheets #GoogleEdu #administration #datavalidation

00:00 Intro working example 01:14 Setting up your Google Sheet 02:59 Buidling the formula 07:16 Add the formula to the rows 08:19 Add in data validation ... https://www.youtube.com/watch?v=k50UiY6m0qM