Hi all
I have a basic Google Sheet that I am using to track investment performance. I'd love to be able to automatically identify the first entry in each year (whether it be the 1st, 8th, 12th Jan etc) and return the investment value on that date, and then the same with the final entry. I would then be able to look at performance growth year on year.
I have included a link to the data set here:
http://docs.google.com/spreadsheets/...it?usp=sharing
As you can see (in yellow) on the ROI tab, I have managed to do this using 'MIN' and 'MAX' values, but of course this is no good if the investment value dips after the first entry, or his higher before the final entry. I therefore want to replace the formulas in C5:D13.
Bookmarks