Hi;
Here is my question. I want to fit a line to an exponential curve in excel, so I can’t use the zero values that occur in my column data. In other cells in the spreadsheet I have calculated the row# of the column where my values turn zero, but I don’t know how to include this into my formula in another cell.
ie. =-LINEST(LN(Sheet1!N6:N147),Sheet1!M6:M147)
I want to be able to specify the “N147” and “M147” values of the ranges above. I can find the row# using the MATCH function, but can I include it in the above formula?
For instance, I know this doesn’t work.
=-LINEST(LN(Sheet1!N6:(_calculated_cellvalue_using_MATCH)),Sheet1!M6:(_calculated_cellvalue_using_another_MATCH)),)
A workaround will do as well, but I would like to know if this thing is even possible. I seem to remember some way of doing this ages ago via CONCANTENATE and EVALUATE, but Evaluate isn’t listed at all, so I don’t know if this is a false memory or not.