Ignore null value
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.
|