Tuesday, October 28, 2014

yogi_Make Used Choices Unavailable In Subsequent DropDown List

                 Google Spreadsheet   Post  #1808
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-28-2014
post by  KenjiMac
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/69v0fGnrevI)
Hide Selected Items from subsequent Drop Down Lists
I need some help to create a voting ballot. I am a long way from an expert with spreadsheets.

We have 10 products. We want to vote to reduce it to 6.

Here is a rough overview:
I want to have 6 question positions where users select from the list of 10.
In question 1, 10 choices.
In question 2, 9 choices (previous choice hidden from choice)
In question 3, 8 (since previous two choices are subracted.

I have created the products as a list on second sheet.
I have created a drop down using Data > Validation > List from range.



I found this for doing it in excel. If it is similar, can someone provide an simple how-to.

Mahalo for your assistance.
-----------------------------------------------------------------------------------------------------------------------------------------