Hi all, I need some help regarding Index/Match as I'm not sure why this isn't working.
<tbody>
</tbody>
in the table above, I want to output which Month has the largest value (so in this case, my output should read Mar)
this is my current formula =index(A1:C1,Match(large(A1:C4,1),A2:C4,1)) - however this gives me an error. If I limit my array to A3:C3 it works fine. Any help is appreciated.
Thanks.
A | B | C | |
1 | Jan | Feb | Mar |
2 | 30.2 | 40.2 | 60.0 |
3 | 5.4 | 15.1 | 90.1 |
4 | 30.1 | 40.5 | 50.3 |
<tbody>
</tbody>
in the table above, I want to output which Month has the largest value (so in this case, my output should read Mar)
this is my current formula =index(A1:C1,Match(large(A1:C4,1),A2:C4,1)) - however this gives me an error. If I limit my array to A3:C3 it works fine. Any help is appreciated.
Thanks.