Longest to Shortest with number and maximum number data name

Copper Contributor
I want to know which formula I use for a table for largest number and also see the largest number row name
1 Reply

@Rbi22 

=LARGE($C$3:$C$19,1)

=CELL("adresse",INDEX(C3:C19,MATCH(E4,C3:C19,0)))

 

Maybe like in the attached file.