| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic range | Excel Worksheet Functions | |||
| Help With Dynamic Range | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic range does not appear in name box | Excel Discussion (Misc queries) | |||
| dynamic range | Excel Discussion (Misc queries) | |||
Hybrid Mode
