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   Feb-01-2014
question by Bee Lini via GMail ( 

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.
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