Hi guys,
I'm trying to compare a range of daily values with that of the daily values from the previous 5 years.
What I have is the daily increase/decrease (in %) of sales of my company. What I want to do, is have excel use this year's daily sales percentage increase/decrease compared to that of the last 5 years, and find the closest 'fit' in terms of which year had the greatest correlation with this year's data.
It sounds painful haha, but I really need to do this, because the manual way of creating charts and trying to match the closest possibility isn't feasible because it isn't really accurate, nor practical the minute you begin using 20 year data instead of 5.
I'd really appreciate any help, or even a direction!
regards,
Shark
I'm trying to compare a range of daily values with that of the daily values from the previous 5 years.
What I have is the daily increase/decrease (in %) of sales of my company. What I want to do, is have excel use this year's daily sales percentage increase/decrease compared to that of the last 5 years, and find the closest 'fit' in terms of which year had the greatest correlation with this year's data.
It sounds painful haha, but I really need to do this, because the manual way of creating charts and trying to match the closest possibility isn't feasible because it isn't really accurate, nor practical the minute you begin using 20 year data instead of 5.
I'd really appreciate any help, or even a direction!
regards,
Shark
