Home » Fashion Innovations Express » Dynamic Named Ranges in Google Sheets

Dynamic Named Ranges in Google Sheets

Alexander Ross • • 2 min read
Dynamic Named Ranges in Google Sheets

I'm trying to replicate some of the dynamic named ranges I use in Excel, in Google Sheets. For example, the following formulas define simple dynamic named ranges in Excel:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

=Sheet1!$K$1:INDEX(Sheet1!$K:$K,COUNTA(Sheet1!$K:$K),1)

However when I use either of these in Google sheets to define a named range I get an "Invalid Range" error. I've trawled the web but can't find any info on defining a Sheets dynamic named range in this way. Is this possible in Sheets?

I don't want to use a solution that involves any scripting - just trying to replicate how it's achieved in Excel.

10
Related questions
0
How to create named ranges dynamically?
5
Referring to Dynamic Named Ranges in VBA
10
Referencing Dynamic Named Range in Excel Formula
Load 7 more related questions Show fewer related questions
Alexander Ross
Author

Alexander Ross

Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.