ExcelBanter - Using LINEST with a sparse data row?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using LINEST with a sparse data row? (https://www.excelbanter.com/excel-programming/395479-using-linest-sparse-data-row.html)

Jo[_2_]

Using LINEST with a sparse data row?

Hi,

Say I have a sparse data row like this:

0 12.00 13.80 16.87 0 12.00

How can I use LINEST so only the non-zero data get considered? How
then LINESt should be written?

Thanks,
Mike

All times are GMT +1. The time now is 03:14 PM.