Hello,
I have made a sample excel to illustrate what I want to accomplish.
I want to find the return for company A,B,C for the specific years: 2017,2018 & 2019.
My thoughts:
I want to find a function that the latest value in 2017 and divides it with the earliest value in 2017 and subtract 1.
Formula: (C24/C12 -1) for 2017 for instance.
The strategy i initially had was to create two LOOKUP() functions that i use to divide to get the return. However, i cannot figure out how to make the lookup function take the last value of a year.
Please comment if I need to clarify more.
Bookmarks