How to find the last cell number of a column and use this as part of another function?

Hello,

I am aware that you can use the following codes to get the last row number/value in the row

Please Login or Register  to view this content.

However, I'm trying to utilize this as part of another function and I keep getting errors.

I am trying to use it as part of the following:

Please Login or Register  to view this content.

Here you can see that my last datacell is row# 9886 but this will change everytime I get new data from my analysis. I would like to, somehow, use the =match() function inside of that LINEST function to automatically lookup what the last number is in any given column and do the calculation that way, i.e:

Please Login or Register  to view this content.

This obviously doesn't work.

Can anyone help?

Originally Posted by daddylonglegs

You can use INDEX with MATCH like this

=LINEST(C2:INDEX(C:C,MATCH(9.9E+307,C:C)),A2:INDEX(B:B,MATCH(9.9E+307,C:C)),TRUE,TRUE)

I knew there would be a way to do it. Thanks, man.