Forum Discussion
Longest to Shortest with number and maximum number data name
I want to know which formula I use for a table for largest number and also see the largest number row name
=LARGE($C$3:$C$19,1)
=CELL("adresse",INDEX(C3:C19,MATCH(E4,C3:C19,0)))
Maybe like in the attached file.