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.

http://www.contextures.com/xlDataVal03.html

Mahalo for your assistance.

-----------------------------------------------------------------------------------------------------------------------------------------