Say I have 3 prices: $1,10 - $1,00 - $0,73
with a monthly return: 0,68% - 0,82% - 0,67%
What formula shall I use to get the price of the highest monthly return? i.e row above LARGE(B2:B4;1)
and second largest, and third largest
Thanks
If I understand you correctly, then you are looking for the value $1.00 as the monthly profit is highest there.
=INDEX(B2:D2,MATCH(LARGE(B4:D4,1),B4:D4,0))
This formula gives you the desired result. In the example, the prices are in B2:D2 and the monthly return in B4:D4.
For the second best result, you must enter a 2 in LARGE().
1 Like
It works, Thanks