TOP 5 From Multiple Rows

[Deagers]

Labour	Cost
Cleaning	200.58
Travel Time	489.56
Wet Time	55.00
Set- UP	855.00
Operating Equipment	780.00
Spotter	200.00
Supervision	1200.00

<tbody>
</tbody>

I need a formula that gives me the top 5 values in Col B and then Displays them with the appropriate Value in Col A As such Below

Supervision	1200.00
Set-Up	855.00
Operating Equipment	780.00
Travel Time	489.56
Cleaning	200.58

<tbody>
</tbody>

Any Help with this one would be greatly appreciated guys

 

[Michael M]

Why not just use an Autofilter with Top 5 results by value
Home>>Editing>>Filter>>Number Filters>>Top10 and adjust as required

 

[Aladin Akyurek]

Using a formula system...

Labour	Cost		Top N	5
Cleaning	200.58		Top N adjusted	6
Travel Time	489.56		Labour	Top Cost
Wet Time	55.00		Supervision	1200
Set- UP	855.00		Set- UP	855
Operating Equipment	780.00		Operating Equipment	780
Spotter	200.00		Travel Time	489.56
Supervision	1200.00		Cleaning	200.58
Plumbing	200.58		Plumbing	200.58

<COLGROUP><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6343" width=178><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3896" width=110><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 881" width=25><COL style="WIDTH: 124pt; mso-width-source: userset; mso-width-alt: 5859" width=165><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3640" width=102><TBODY>
</TBODY>

E1: 5

E2, just enter:

=COUNTIF(B2:B9,">="&LARGE(B2:B9,E1))

D4, control+shift+enter, not just enter, and copy down:

=IF($E4="","",INDEX($A$2:$A$9,
  SMALL(IF($B$2:$B$9=$E4,ROW($A$2:$A$9)-ROW($A$2)+1),
  COUNTIF($E$4:E4,E4))))

E4, just enter and copy down:

=IF(ROWS($E$4:E4)<=$E$2,LARGE($B$2:$B$9,ROWS($E$4:E4)),"")

 

[ratanbhushan2910]

=LARGE($B$3:$B$9,ROW(A1))

use this function

the range is the price, keep that fix