Macro to Find the Max ?

  • Thread starter Thread starter Anandh R
  • Start date Start date
=INDEX(B1:B100,MATCH(MAX(A1:A100),A1:A100,0),1)

where the range you want to search Max is A1:A100 and you want to return the
cell in B1:B100.

Regards,
Peter T
 
Back
Top