Google Spreadsheet Post #1201
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 19, 2013
user Diana Tashjian (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!category-topic/docs/spreadsheets/APq0Hgo1RW8)
I understand that Excel uses the ctl-shift-enter method to specify an array formula and that Google uses the function ARRAYFORMULA. I have several very large Excel spreadsheets with many array formulas that I want to upload and convert to Google spreadsheets. The array formulas do not get converted. I can't figure out a way to avoid having to manually change hundreds of array formulas in my converted Google spreasheets. Help!
in the following I present a WorkAround solution wherein the formula is modified in Excel so it works in Excel as well as when imported into Google spreadsheet