| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i get the slope function to ignore missing data?
I have a spreadsheet that needs to calculate the slope of a line. The x
values are in column a, the y values in column d. The slope function in excel 2003 works just fine for this purpose until it encounters missing data. The slope function returns #N/A. I have tried entering #N/A for the missing data but the result is the same. How can I get it to simply ignore my missing data? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
| Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
