Dear all,

I am using the following formula for showing a trendline equation:

=LINEST(TRANSPOSE(C11:KE11),TRANSPOSE(C8:KE8)^{1,2})

The formula works if values are present in the whole range (from C to KE). If there are blanks in the last part of the range the formula will not work.

Is there a way of adapting the formula so that the formula picks up the values present on that range avoiding blanks?

Thanks!

Kind regards