I want to take monthly data and change is so the third month of the quarter is used for the quarter value. For instance in January to March it would take the March value and report that for quarter one. I have attached the data.
data.xls
I want to take monthly data and change is so the third month of the quarter is used for the quarter value. For instance in January to March it would take the March value and report that for quarter one. I have attached the data.
data.xls
Hi Boo123
It's not clear to me what you're trying to achieve...add some "After" data to your Sample File.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks