How do you get top 5 values in Excel?

Answer 1

The functions you want are INDEX, MATCH and LARGE. For example, if your values are in cells A2-A28 and their corresponding labels in B2-B28, put the following formula in some other column for the largest value and copy down 4 more rows for the next 4.

=INDEX($B$2:$B$28,MATCH(1,INDEX(($A$2:$A$28=LARGE($A$2:$A$28,ROWS(D$1:D1)))*(COUNTIF(D$1:D1,$B$2:$B$28)=0),),0))