locating the cell that contains the MIN or MAX

[JR]

working horizontally, I have found the MIN and Max of the data on the row
{example: =MIN(C2:BE2)}

I now would like to know what cell in row 2 holds the MIN or MAX.

Any suggestions?

 

[JR]

Thanks!

Both work fine.

Try...

=SUBSTITUTE(CELL("address",INDEX(C2:BE2,MATCH(MIN(C2:BE2),C2:BE2,0))),"$"
,"")

or

=ADDRESS(ROW(C2:BE2),MATCH(MIN(C2:BE2),C2:BE2,0)+COLUMN(C2)-1,4)