View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fallowfz fallowfz is offline
external usenet poster
 
Posts: 12
Default using the 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