Friday, January 31, 2014

yogi_Working With Source Data As A Formula Output In New Google Sheets versus Old Google Sheets - part 3

                                         Google Spreadsheet   Post  #1510
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-01-2014
question by Bee Lini via GMail (https://mail.google.com/mail/u/0/#inbox/143e5a80f84ed371) 


Hi Yogi,
Sorry to bug you with a personal question such as this. I was speaking with Adam Lusk about a project and he referenced you. I was wondering if you could take a peek at my formula. I have spent countless hours trying to find a work around to no avail. It use to work on the old google sheets, but I can't wrap my brain around the current error.
If you could take a look and point me in the right direction, or solve it for me I would be very appreciative.

https://docs.google.com/spreadsheets/d/1nx2suoNLcXmnX19ZE2mCTlsPXEdPJenYeXyZdF2zyXE/edit#gid=1448742359
Hope all is well
--------------------------------------------------------------------------------------------------------------------------------------------------------

using a combination of FILTER and QUERY functions
this (part3) is setup in Old Google Sheets -- for setup in New Google Sheets see part 4