| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ignore null value
On 21 Jan, 17:17, nerv2010 wrote:
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. |
| Reply |
| 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 | |||
Linear Mode
