-
Solved: Looking up date and calculating monthly returns
Hi, I've been stuck on this a long time and hopefully someone can figure this out. I've tried pivot tables but its not visually acceptable here unfortunately. So I hope someone can write a macro to solve it.
Column A has dates which i need the macro to detect and calculate monthly returns from Column B. The figures should go into a table as shown
eg. for March 2009----detect that month started at Row 2 and ended Row 23.......so calculate (B23-B2)/B2....which is about -1%.
thanks
i will be extremely grateful if this is somehow solved, although i have low expectations of that
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules