Saturday, January 18, 2014

yogi_Work With Data From Another Sheet Based On Cell Ranges As Noted on Host Sheet

                                          Google Spreadsheet   Post  #1488
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-17-2014
post by Ersun Gublas (!category-topic/docs/spreadsheets/3MN9GuDI-GE)
new sheets formula problem
I want to transfer my old sheets to new sheets.
So i download them as xlsx and upload again.
All works fine until i face below formula.

This formula works in old sheets and downloaded excel, but not in new sheets, it gives formula parse error.


The old version of sheets:

Converted new sheet version: