Dynamic Named Range based on Rows and Columns

ravumisu · Jan 11th 2021

Hi All

I need a little help please.

I need to create a Dynamic Named Range based on Rows and Columns

I can use COUNTA for Rows down, but How do extend that to include an expanding column range too

**Carim** · Jan 11th 2021

Hi,

There is no difference between Rows and Columns ...

Code

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

Hope this will help

**royUK** · Jan 11th 2021

You don't necessarily need Named Ranges these days. Convert the data to a Table.

Participate now!