Friday, June 8, 2012

yogi_Extract Items From A List Based On Items In One Column Meeting A DropDown And In The Other Column Not Meeting Another DropDown

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #585    Jun 09, 2012     www.energyefficientbuild.com.

user blockscott said:
Google Spreadsheet Help needed
I want to be able to make a spreadsheet with a header row that has pull downs to pick from to sort the rows below it.  If anyone has or knows of a template that i can edit that would be awesome, if not any help would be appreciated.
So, what i would like to be able to do is from lets say Row 4 Column 1, I want to pick from a pulldown that has 3 options (lets call them: Red, Yellow, and Blue).  So if i pick Yellow from the pull down, it displays all rows below that have Yellow in column 1.  Then say i have a pull down in Row 4 Column 2 that has 2 options (lets call them: good and bad).  So now if i pick Good from the pull down in row 4 column 2, it displays all Rows with Yellow in column 1 and Bad in column2.
anyones help in this would be very much appreciated, Thanks

----------------------------------------------------------------------
following is a solution to the problem