I have the following table of data with the row of focus highlighted in red. This is being done on Google Sheets.
With the following summary page and row of interest highlighted in red
The question is:
The answer for "Maximized holding period" is the year "IRR" has the highest percent, in this case, it would be year 5 (expanded an extra decimal it is higher than year 6). I want the displaying answer on the summary page to be "year 5", not 13.14%. How would I go about crafting a formula to make that happen?