How Sort by Largest to Smallest Column by Formula

In D2 and copy down, =INDEX($A$2:$A$6, MATCH(LARGE(B$2:B6, ROWS(D$1:D2)-1), $B$2:$B$6, 0) )

Please ask question in the body of your post rather than referring people to a workbook.

And merging cells in Excel is terrible practice.

See if this will do:

Originally Posted by shg

In D2 and copy down, =INDEX($A$2:$A$6, MATCH(LARGE(B$2:B6, ROWS(D$1:D2)-1), $B$2:$B$6, 0) )

Please ask question in the body of your post rather than referring people to a workbook.

And merging cells in Excel is terrible practice.

Didn't spot those duplicate values of "30" did you...hehe.

Termal,

The others will be offline presently (US) but I confess I don't/can't see the problem -- the existing approach will still work, eg:

C15: =RANK($B15,$B$15:$B$24)+COUNTIF($B$15:$B15,$B15)-1
copied down

D15: =INDEX($A$15:$A$24,MATCH(SMALL($C$15:$C$24,ROWS($B$15:$B15)),$C$15:$C$24,0))

You can do this without using C if that's your intention but it would IMHO be ill-advised given adverse performance impact, eg:

D15:
=INDEX($A$15:$A$24,MATCH(LARGE($B$15:$B$24+(0.1-(ROW($B$15:$B$24)/1000)),ROWS(D$15:D15)),$B$15:$B$24+(0.1-(ROW($B$15:$B$24)/1000)),0))
committed with CTRL + SHIFT + ENTER
copied down

whats the difference betwen this question and the one posted at
http://www.excelforum.com/excel-misc...-function.html ?
but the same answer applies

I get the feeling you created the second chart and didn't even TRY to put the two sets of formulas from my first answer into the second example? Did you? If you don't, you'll never know for sure if you understand the formulas given.

This sheet is the same as the first, same formula, new ranges...

Deliverance, welcome to the forum

This threads is over 4 years old, I doubt anyone is still monitoring it