Ignore null value

[nerv2010]

I'm trying to figure out the easiest way to ignore a value.
Currently I'm using a simple x,y set of data and lineest to get a
slope/intercept.
What I'd like to do is to have the ability to remove a pair of data from
that set and recalculate the slope/intercept.
The only thing I've been able to do is to revaluate the cell as a 0 which
still throws off the actual measured 0 values.

 

[Alan]

I'm trying to figure out the easiest way to ignore a value.
Currently I'm using a simple x,y set of data and lineest to get a
slope/intercept.
What I'd like to do is to have the ability to remove a pair of data from
that set and recalculate the slope/intercept.
The only thing I've been able to do is to revaluate the cell as a 0 which
still throws off the actual measured 0 values.

Can you not make a copy of your data set to another area and delete
the rows on which the unwanted data pairs are on from the copy. Then
do your analysis on the modified data set.