Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Spreadsheet range names

In Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more legible. In most formulas, one can use the range C:C to denote the entire C column, and C2:C to denote the entire C column after and including C2.

Is there a way to create range names of the same nature? When I try C:C or C2:C or Sheet!C:C or 'Sheet'!C:C I always get the error "The range you specified is not in a valid range format." I would like the range name to expand as my form adds rows to my spreadsheet. Thanks.

like image 563
Daniel Gill Avatar asked Mar 06 '09 06:03

Daniel Gill


1 Answers

I just discovered the if you use the '-' operator, it starts from the bottom row. So,

=INDIRECT("-D:D12")

starts from the last row and works it's way up to D12!

like image 165
Will Charlton Avatar answered Sep 30 '22 15:09

Will Charlton