Hi Everyone,
I'm new to this site and excel in general.
I'm trying to create a list on Sheet 1 that will expand and contract. Is it possible to use the current cell range of this list in another formula? I am currently trying to use =OFFSET('Sales Analysis'!$D$8,0,0,COUNT('Sales Analysis'!$D:$D),1) for the initial range. Then I want to insert the range with numbers greater than 0 into the cell range in the formulas below without having to manually adjust them.
=LINEST(B5:B12,LN(A5:A12))
=INDEX(LINEST(B5:B12,LN(A5:A12)),1)
Bookmarks