Dear Friends,
I need your help for a routine work I undertake.
I need to capture the frequency table as per the sheet attached for various periods & their rentals.
I have been able to capture changes in frequency (i.e. monthly, quarterly,halfyearly, yearly) but not the changes in rentals for various period. i.e. if rentals change from $100 in period 2011-12 to $200 in period 2012-13 i am stuck. (Pls. refer file attached)
Hope you guys can guide.
Regards,
Bookmarks