LINEST and managing missing values

[SDruley]

The attached worksheet describes how a second order polynomial has been characterized not only in the graph but, more importantly, in the context of the worksheet.
If one deletes any of the data values an error occurs in the array field.
My question is how can one compensate for this. NA() also does not work.
Unfortunately, in real life, one can not assume that real values will always be available.

Stephen Druley

[shg]

I think you need to delete lines for which you don't have complete data pairs.

[SDruley]

I think you need to delete lines for which you don't have complete data pairs.

shg,

Thank your for your prompt response. My application does not allow me to delete unpaired data points so I am left with the problem of how to create a workaround.
Any ideas?

[pb71]

If one deletes any of the data values an error occurs in the array field.
My question is how can one compensate for this. NA() also does not work.

Can you delete data values from either column, one column, both columns?
I don't know if this would be viable, but, if you were deleting data values from both data columns:

Make x and y dynamic ranges:

x:
=OFFSET(Sheet1!$B$4,0,0,COUNT(Sheet1!$B:$B),1)

y:
=OFFSET(Sheet1!$C$4,0,0,COUNT(Sheet1!$C:$C),1)

Delete the data values and then data sort by PR3 or GR.