| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset code for dynamic row# & multiple columns in LINEST function
Hi,
I found this offset formula in a different post offset(A1,1,0,counta(A:A)-1,1), I think this is kind of what I am looking for, but I'm not positive, but I would need it for multiple columns. Essentially i need the following, (x being a dynamic row number being determined by the last cell to have a value in the range). =LINEST(B2:Bx,C2:Fx,TRUE,TRUE) Any help is greatly appreciated, Thanks! Best, -- RJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET for multiple columns & combobox format | Charts and Charting in Excel | |||
| Dynamic reference in OFFSET function | Excel Worksheet Functions | |||
| Offset function problem-Dynamic range | Excel Discussion (Misc queries) | |||
| Offset function and Dynamic Ranges | Excel Discussion (Misc queries) | |||
| Vlookup/match/offset over multiple columns of lable | Excel Discussion (Misc queries) | |||
Threaded Mode
