I am not sure if OFFSET is the correct formula. I am returning a #VALUE error.
For the month of April (Row 6) I want to know which years have had the biggest profit. I do this in the yellow box (the one with the red circle around it) with this formula =MAX('CC Yearly Sales'!C6:E6,1). I then do the same for the 2nd and 3rd biggest years as shown above.
My error is occurring when I then want to see the year the top 3 figures are.
This is the formula I am using. =OFFSET(MAX('CC Yearly Sales'!C6:E6,1)),-4,0)
I think I am way off... I would love some help if anyone can solve my problem I would be so grateful!
Bookmarks