Saturday, April 4, 2015

yogi_Compute Sum Of Prices Based On Selected Features From Data In Different Sheets


                                           Google Spreadsheet   Post  #1935
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr-04, 2015
question by joebaz:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Yr3Em_CwmYY
Alternative to Filter function for displaying a list of selected cells
Hey Docs community, 

I've had some success outputting a set of cells based on a data validation toggle by using the FILTER function, but unfortunately the FILTER function doesn't give me the flexibility to manipulate the output. I want to know if there is an alternative way to display a set of cells based on the selection of inputs from a different sheet. The catch is that the output of rows cannot contain and blank rows in between. (i.e. If I choose A1 and C1, the output of those on the subsequent sheet show be rows A and B, not A and C.) 

It's probably better to see the sample spreadsheet I have created to demonstrate what I am seeking. 
https://docs.google.com/spreadsheets/d/1C4LTsspe1Jm7LpojanWuEfrIkfit_YFAf6dUdRVMMyg/edit#gid=0

Thanks in advance for your help!

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