Table to create by highest first

[Dazlancs]

Hi all,

I am trying to get a table that is created based on the numbers i have.

eg i have the following data in cells A1:B4

1 List 1 1.00%
2 List 2 2.00%
3 List 3 3.00%
4 List 4 4.00%

Ineed a formula that will look at them and put them in highest order first in cells E1:F4

1 List 4 4.00%
2 List 3 3.00%
3 List 2 2.00%
4 List 1 1.00%

Can anyone help? I think i need to use an index but don't know how

Thanks,

Darren

 

[Trevor G]

Darren,

Look at highlighting the table then copy it to column E then use Sorting and sort from the percentage column from Largest to Smallest.

 

[Mindpsyche]

So if your list begins in Cell A1

A1 B1 C1
[TABLE="width: 144"]
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>[TR]
[TD="class: xl23, width: 64, bgcolor: transparent"]List 1[/TD]
[TD="class: xl22, width: 64, bgcolor: transparent, align: right"]1.0%[/TD]
[TD="class: xl22, width: 64, bgcolor: transparent"]List 4[/TD]
[/TR]
[TR]
[TD="class: xl23, bgcolor: transparent"]List 2[/TD]
[TD="class: xl22, bgcolor: transparent, align: right"]2.0%[/TD]
[TD="class: xl22, bgcolor: transparent"]List 3[/TD]
[/TR]
[TR]
[TD="class: xl23, bgcolor: transparent"]List 3[/TD]
[TD="class: xl22, bgcolor: transparent, align: right"]3.0%[/TD]
[TD="class: xl22, bgcolor: transparent"]List 2[/TD]
[/TR]
[TR]
[TD="class: xl23, bgcolor: transparent"]List 4[/TD]
[TD="class: xl22, bgcolor: transparent, align: right"]4.0%[/TD]
[TD="class: xl22, bgcolor: transparent"]List 1[/TD]
[/TR]
</TBODY>[/TABLE]

The formula in cell C1 =INDEX($A$1:$A$4,MATCH(LARGE($B$1:$B$4,ROWS($B$1:B1)),$B$1:$B$4,0),1)

 

[Mindpsyche]

Darren,

Look at highlighting the table then copy it to column E then use Sorting and sort from the percentage column from Largest to Smallest.

Much faster, and easier.