How to save typing by using current row in formula?

  • Thread starter Thread starter Angus
  • Start date Start date
A

Angus

I have 300 rows to paste this formula:

=INDEX(LINEST(B1:Current_B_Row,A1:Current_A_Row,,TRUE),1,2)

Eg row 1 will have:
=INDEX(LINEST(B1:B1,A1:A1,,TRUE),1,2)

and row 300 will have:
=INDEX(LINEST(B1:B300,A1:B300,,TRUE),1,2)

If I could use some sort of current row in formula then I could just
paste into all the rows savging me a LOT of typing. anyone know how I
could do this. Otherwise I will have to paste into all and edit each
cell - which will be a major pain.

Angus
 
=INDEX(LINEST(INDIRECT("B1:B"&ROW()),INDIRECT("A1:A"&ROW()),,TRUE),1,2)
best wishes
 
Back
Top