Hi,
I need help with formula to calculate week on week and year on year
changes. for example the data is
Year 8-Sep 15-Sep 22-Sep
29-Sep
2009 165.60 167.80 170.80
2010 174.80 174.50 174.90
Every week one data (number) will be added to year 2010. I am looking
to formulate a report which will be as below:-
22-Sep wow wow % yoy yoy%
Price 174.9 0.40 0.23% 4.10 2.40%
That, the report will populate the latest date for which data for 2010
is available(i.e. 22-Sep), populate that price, calculate week on week
change, wow percentage, calcuate year on year change and percentage.
Every week the formula should automatically incorporate the addition
data point.
please help
regards
Harris
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
