|
Dynamic Range
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 |
Dynamic Range
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" wrote in message oups.com... 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 |
Dynamic Range
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! On May 4, 12:20 pm, "T. Valko" wrote: 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" wrote in message oups.com... 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- Hide quoted text - - Show quoted text - |
Dynamic Range
There are a lot of things to consider when building a dynamic range!
Biff "bony_tony" wrote in message oups.com... 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! On May 4, 12:20 pm, "T. Valko" wrote: 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" wrote in message oups.com... 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- Hide quoted text - - Show quoted text - |
Dynamic Range
Yeah, sorry I was a bit vague, quickly wrote the message before I went
to lunch Thanks anyway On May 4, 1:29 pm, "T. Valko" wrote: There are a lot of things to consider when building a dynamic range! Biff "bony_tony" wrote in message oups.com... 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! On May 4, 12:20 pm, "T. Valko" wrote: 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" wrote in message groups.com... 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- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com