matchmax formula

[Afarag]

Dears,

i want to know using match&max formula

EX:

Ahmed-------44

Islam-------78

Hosam-------20

Osama------100

I want to get the name who achieve the maximum value

and i want to get the top second name who achieve the high value

 

[Colin Legg]

Max:

=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))


2nd largest:

=INDEX(A1:A4,MATCH(LARGE(B1:B4,2),B1:B4,0))

 

[Afarag]

Dears Colin Legg,

Gratefully thank you very much