Sort by percentage (small to large)

[BradMS]

Hello,
A3:G200 has my data that gets pulled in by macro.

In I10:I210, I would like a formula or a automatic method to sort D3:D200 (percentage value) from smallest to largest while keeping original data in the columns next to it.

As of now I have I10 filled down to I210 =IF(D3="","",SMALL($D$3:$D$210,ROWS(D$3:D3))), This sorts my percentages from smallest to largest.

I cannot figure out a way to link the other cells with it. So as i add new data it puts the lowest % first, as they reach 100% it goes to the bottom of the list. As my list grows from 210 items to 1000's I always want the outstanding ones near the bottom while keeping the other information from the other columns with it.

0%
0%
12%
15%
55%
75%
100%
100%
100%
100%
100%

 

[NiMip]

I would use the RANK formula. It gives you the rank of a value in a range, and you can set it as ascending or descending

Keep in mind that if you have multiples of the same value, they will all be the same rank. The next different value will be given a rank that is adjusted to account for how many multiples there were at the previous rank.

 

[BradMS]

How do I Rank, a whole row?