Returning The 5 Name of the highest 5 value field

**Biplab1985** · 10-25-2016, 02:06 PM

Hello,

I know the formula to return the name of the highest value in a dataset. Now i need the names corresponding to their highest 5 values.

Please Login or Register  to view this content.

**JieJenn** · 10-25-2016, 02:14 PM

Maybe use formula like =INDEX($A$1:$A$28,MATCH(LARGE($B$1:$B$28,D3),$B$1:$B$28,0)). See the file I attached.

**Biplab1985** · 10-25-2016, 02:18 PM

Thanks for your input. Is there a way to get the bottom 5 names corresponding to their values

**JieJenn** · 10-25-2016, 02:25 PM

Change Large to Small --> SMALL($B$1:$B$28,D3)

Re: Returning The 5 Name of the highest 5 value field