Dynamic Range

[bony_tony]

Hi,
I need to set up a dynamic range, but can't remember what functions I
need to use...
I want my range to be 2 cells down from the last the last row used in
column K, in column L.

So if the last used cell in column K is K1000, I want my range to be
L1002...

Thanks

 

[T. Valko]

I want my range to be 2 cells down from the last the last row

used in column K, in column L.
So if the last used cell in column K is K1000, I want my
range to be L1002...

Do you only want to refer to a *single* cell or a RANGE (multiple) of cells?

What do you want to do with this "range" of cells?

What type of data is in column K? Text? Numbers? Both? Are there any empty
cells within the range of column K? Are there any formulas in column K that
return formula blanks? If there is no data in column K what do you want to
do? Does the data in column K start in row 1 (K1) ?

Biff

 

[bony_tony]

It's ok, you've pointed me in the right direction. Got there with

=OFFSET(Invoices!$K$5,65533-COUNTBLANK(Invoices!$K$5:$K$65536),1)

Thanks!

 

[T. Valko]

There are a lot of things to consider when building a dynamic range!

Biff

 

[bony_tony]

Yeah, sorry I was a bit vague, quickly wrote the message before I went
to lunch
Thanks anyway