| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using slope function with non contiguous cells
Is there a way to use non contiguous cells with the slope function?
Specifically, if y's and x's contain non contiguous values. SLOPE(known_y's,known_x's) A simple example... x's y's 1 10 2 12 3 30 4 32 5 60 6 68 Where... desired x's = 1, 3, 5 desired y's = 10, 30, 60 Thanks, -Zack |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect Function Doesn't like non-contiguous ranges | Excel Discussion (Misc queries) | |||
| Non-contiguous cells | Excel Discussion (Misc queries) | |||
| Anomolous behaviour of slope function. | Excel Worksheet Functions | |||
| Calculating slope, intercept, LOGEST with empty cells in data | Excel Worksheet Functions | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
Threaded Mode
