Finding the slope of a trendline without a graph
 

Steve,
You can use the function
=INDEX(LINEST(known_y's,known_x's),1)

Here known y's are nothing but the range that contains the 12 month's sales
for each customer. Known x's are an array containing 1,2,3.. that is
{1,2,3,4,5,6,7,8,9,10,11,12}. The one at the end is for getting the slope
since the Linest function actually returns an array. We are looking at the
first element of the array.


"Steve D" wrote:

Hi,
I have a large amount of data, it is a list of 2000 customer names with
each of their monthly sales for 12 months. I am trying to find an easy way of
ranking these customers based on their sales trend. My thought is adding a
column which shows the slope of their linear trendline. I can get the slope
if I use a graph but I am really just looking for the number. Can someone
help figure out how I can do this using Excel formulas? Thanks for your help.

--
Thank You,
Steve