Forum Discussion

AlexEanbu's avatar
AlexEanbu
Copper Contributor
Oct 10, 2023

MAX FUNCTION

=MAX(ADDRESS(ROW(A3),MATCH(A3,A2:I2,FALSE()),4):I3)

 

 

  • AlexEanbu 

    I guess you mean

    =MAX( INDEX(B3:I3, MATCH(A3, $B$2:$I$2, 0) ):I3 )

    ADDRESS(...):I3 doesn't work. ADDRESS returns cell address as the text, not reference on that cell.

  • mathetes's avatar
    mathetes
    Silver Contributor

    AlexEanbu 

     

    Instead of an image, you would be helping us help you if you posted a copy of the actual spreadsheet. Put it on OneDrive or GoogleDrive with a link here that grants access to it.

Resources