Find the last row number of a named range in google sheets

[ShadowRider]

In excel, I can create a table and find the first and last row of said table with functions like =min(row(table1)), =max(row(table1)).

I'm trying to emulate the functionality in google sheets and I thought a named range would be the appropriate way for this. For first row, this works: =min(row(named range)). (Actually, just =row(namedrange) works which is why): =max(row(named range)) does not work. Is there a simple way to get the last row in a named range regardless if it contains any data?

Is there a better approach to achieve this excel table-esque capability in google sheets?

Thanks,
-Eric

 

[RoryA]

You should be able to do something like:

=row(named range)+rows(named range)-1

 

[ShadowRider]

Very nice and simple. Thanks!