![]() |
Finding the slope of a trendline without a graph
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 |
All times are GMT +1. The time now is 03:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com