Notifications
Clear all
Topic starter
how can i get the month in formula column based on higher value
| TYPE | jan | feb | mar | apr | may | jun | jul | aug | sep | oct | Formula |
| MOC | 1 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | 1 | 1 | JUL |
| JACK | 2 | 2 | 2 | 2 | 2 | 10 | 6 | 2 | 2 | 2 | JUN |
| ROSE | 3 | 3.5 | 11 | 4 | 4 | 2 | 4 | 4 | 4 | 4 | MAR |
| KITTY | 12 | 2 | 5 | 5 | 5 | 5 | 5 | 2 | 3 | 6 | JAN |
Posted : 01/11/2023 8:29 am
Hi,
You haven't said what version of Excel you have. If you can use XLOOKUP try this
=XLOOKUP(MAX(B2:K2),B2:K2,$B$1:$K$1)
or with INDEX MATCH
=INDEX($B$1:$K$1,1,MATCH(MAX(B2:K2),B2:K2,0))
Phil
Posted : 01/11/2023 9:17 pm
Topic starter
Thanks Philip its working fine.
Posted : 02/11/2023 12:58 am
