Copying Row Headers

[Ragarm13]

I have a spreadsheet similar to this. I am filtering the column of numbers for the 3 highest, which works well. What I am wondering is how do I get the labels to follow the data?

Say I have two spreadsheets. I am using LARGE to sort through one sheet and put results on a different one.
[TABLE="width: 500"]
<tbody>[TR]
[TD]TIPS
[/TD]
[TD]23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HATS[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PINS[/TD]
[TD]92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAPS[/TD]
[TD]74[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ranman256]

cant you just sort these 2 columns?

 

[sheetspread]

You can sort or set a pivot table. Here's a formula solution though:

Excel 2010
	A	B
1	TIPS	23
2	HATS	12
3	PINS	92
4	CAPS	74
5
6
7	92	PINS
8	74	CAPS
9	23	TIPS
Sheet5

Cell Formulas
Range	Formula
A7	=LARGE($B$1:$B$4,ROW(A1))
B7	=VLOOKUP(A7,CHOOSE({2,1},$A$1:$A$4,$B$1:$B$4),2,0)

 

[Ragarm13]

This seems to work great! Thank you!

You can sort or set a pivot table. Here's a formula solution though:

Excel 2010

	A	B
TIPS
HATS
PINS
CAPS
PINS
CAPS
TIPS

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]23[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]12[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]92[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]74[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]92[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]74[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]23[/TD]

</tbody>

Sheet5​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A7[/TH]
[TD="align: left"]=LARGE($B$1:$B$4,ROW(A1))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B7[/TH]
[TD="align: left"]=VLOOKUP(A7,CHOOSE({2,1},$A$1:$A$4,$B$1:$B$4),2,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]