Hi, I am trying to check a table/range for what the maximum change in percent is and to get the year, ex. 2019, in which the biggest change occurs in.
I am tying to use MAX and MATCH formulas w/o success. In my dataset I have more years and more values but it seems fitting to post 3 values here.
<tbody>
</tbody>
In the above example I would like to get the following output:
The biggest change occurs in year 2019 with 20,3...%.
Also, if possible I would like to rank the years from largest to smallest or vice versa, in my dataset I have more years and more values.
Year Rank
2017 3
2018 2
2019 1
I am tying to use MAX and MATCH formulas w/o success. In my dataset I have more years and more values but it seems fitting to post 3 values here.
2017 | 2018 | 2019 |
0,196 | 0,199 | 0,203 |
<tbody>
</tbody>
In the above example I would like to get the following output:
The biggest change occurs in year 2019 with 20,3...%.
Also, if possible I would like to rank the years from largest to smallest or vice versa, in my dataset I have more years and more values.
Year Rank
2017 3
2018 2
2019 1