Google Spreadsheet Post #1102
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 9, 2013
user BeeCon :(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/RJysoNHjelk)
Convert a keyword search macro into workable script
Hi guys, I am keeping at this. I've swtiched from macros/scripts to functions. I could really use some help writing this as I think its too advanced for me.
I have tried: VLOOKUP, QUERY, FILTER functions which I can't get to work.
I have created a sheet with fake data to express what I want to do with expected results.
Heres a link:
https://docs.google.com/a/
there are many hidden columns which on the real sheet will also have data I would like copied to my 'Expected Results' section. I have hidden these columns for simplicity.
Any ideas?
BRIZZLE!!!
-----------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem
