ExcelBanter - using slope function with non contiguous cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - using slope function with non contiguous cells (https://www.excelbanter.com/excel-worksheet-functions/189148-using-slope-function-non-contiguous-cells.html)

fallowfz

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

Jim Thomlinson

using slope function with non contiguous cells

Nope... The ranges must be contiguious...
--
HTH...

Jim Thomlinson

"fallowfz" wrote:

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

All times are GMT +1. The time now is 05:09 AM.