using slope function with non contiguous cells

  • Thread starter Thread starter fallowfz
  • Start date Start date
F

fallowfz

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
 
Back
Top