| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| Generating blank or null cells that the Histogram Data Analysis tool will ignore | Excel Worksheet Functions | |||
| Null, "null", vbNull, vbNullString, vbEmpty | Excel Programming | |||
| Help...code needed to ignore null cells | Excel Programming | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Threaded Mode
