View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nerv2010 nerv2010 is offline
external usenet poster
 
Posts: 1
Default 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.