Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to compare a set of month with the same set of month -1.
ie. if I highlight the months Jan2014-Feb2014-March 2014, I would like to have a column next to the previous where I have the sales value of Dec2013-Jan2014-Feb2014.
Year | |||||||||||
2011 | 2012 | 2013 | 2014 | ||||||||
months | |||||||||||
jan | feb | mar | apr | may | jun | jul | ago | sep | oct | nov | dec |
sales | ||||||
jan '14 | feb '14 | mar '14 | dec '13 | jan '14 | feb '14 | |
client | ||||||
client | ||||||
client | ||||||
client | ||||||
client | ||||||
client |
if I highlight 5 months I'll have the comparison Jan'14/Feb '14/Mar '14/Apr '14/May '14 VS Dec '13/Jan'14/Feb '14/Mar '14/Apr '14 and so on...it is possible (and if yes, how) to do it through set analysis or I need to write a macro?
hopefully this will help...sorry for not being clear enough...
aha ...
Let me know if you like my v2 example
you rock man!!!!! thank you so much!!!! really helpfull!!! that's what I was looking for!!!
A little bit optimised ....