mbrown2626
New Member
- Joined
- Mar 22, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Formula in Cell AY5
=IFERROR(INDEX($AZ$3:$BM$3,MATCH(MAX(AZ5:BM5),AZ5:BM5,0)),"")
As you can see, Cells BA5 and BB5 have the same value which are both the "MAX". how do I get the value in AY5 to return M02 vs M01? Basically I have multiple cells with the max value so I need the last one in the row that is the max.