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.

TIPS	23
HATS	12
PINS	92
CAPS	74

<tbody>
</tbody>

 

[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
1	TIPS	23
2	HATS	12
3	PINS	92
4	CAPS	74
5
6
7	92	PINS
8	74	CAPS
9	23	TIPS

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

Worksheet Formulas Cell 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) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>