TOP 5 From Multiple Rows

[Deagers]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Labour[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]Cleaning[/TD]
[TD]200.58[/TD]
[/TR]
[TR]
[TD]Travel Time[/TD]
[TD]489.56[/TD]
[/TR]
[TR]
[TD]Wet Time[/TD]
[TD]55.00[/TD]
[/TR]
[TR]
[TD]Set- UP[/TD]
[TD]855.00[/TD]
[/TR]
[TR]
[TD]Operating Equipment[/TD]
[TD]780.00[/TD]
[/TR]
[TR]
[TD]Spotter[/TD]
[TD]200.00[/TD]
[/TR]
[TR]
[TD]Supervision[/TD]
[TD]1200.00[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Supervision[/TD]
[TD]1200.00[/TD]
[/TR]
[TR]
[TD]Set-Up[/TD]
[TD]855.00[/TD]
[/TR]
[TR]
[TD]Operating Equipment[/TD]
[TD]780.00[/TD]
[/TR]
[TR]
[TD]Travel Time[/TD]
[TD]489.56[/TD]
[/TR]
[TR]
[TD]Cleaning[/TD]
[TD]200.58[/TD]
[/TR]
</tbody>[/TABLE]


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...

[TABLE="width: 436"]
<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>[TR]
[TD="class: xl67, width: 178, bgcolor: white"]Labour[/TD]
[TD="class: xl67, width: 110, bgcolor: white"]Cost[/TD]
[TD="class: xl65, width: 25, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 165, bgcolor: transparent"]Top N[/TD]
[TD="class: xl65, width: 102, bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Cleaning[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]200.58[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]Top N adjusted[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Travel Time[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]489.56[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]Labour[/TD]
[TD="class: xl66, bgcolor: transparent"]Top Cost[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Wet Time[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]55.00[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Supervision[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1200[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Set- UP[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]855.00[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Set- UP[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]855[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Operating Equipment[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]780.00[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Operating Equipment[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]780[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Spotter[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]200.00[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Travel Time[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]489.56[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Supervision[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]1200.00[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Cleaning[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]200.58[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 178, bgcolor: white"]Plumbing[/TD]
[TD="class: xl69, width: 110, bgcolor: white"]200.58[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Plumbing[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]200.58[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

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