Wednesday, April 18, 2012

yogi_List All Columns In A Specified Range That Are Blank

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #507    Apr 18, 2012     www.energyefficientbuild.com.

user c.perigel said:
Is there any way to tell if a column is completely empty? It's kind of a long spreadsheet, about 3500 rows. Some of the data is kind of sparse. It looks like some columns may not be being used at all. Is there some way to tell if there is any data there without having to visually check the whole thing?
----------------------------------------------------------------------
following is a solution to the problem
 

No comments:

Post a Comment