ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reading content of array formula (https://www.excelbanter.com/excel-programming/317973-reading-content-array-formula.html)

Papa Jonah

Reading content of array formula
 
Is there a way to determine the first row that is used in an array from
another cell.
For example, in cells F7:G11, I have the following array:

{=LINEST(B25:B169,A25:A169,TRUE,TRUE)}

I would like another cell, say F5, to indicate the cell identified (in this
case B25 or A25). The reason is that I would then like to use a match
function or a lookup function to tell me the date that corresponds with that
point in the array.

I tried using =mid(F7,10,2). But that just returns the digits from the
resultant calculation.

Thanks.


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com