Returning the Highest values in a column

pablorynx said:

Imagine two columns of cells, one containing text, the other containing values.
In the first cells of the third column, I want to display the four largest values from the second column.
In the first cells of the fourth column, I want to display the names associated with those values.

Click to expand...

Aladin Akyurek said:

...

Formulas...

D1:

=MAX(IF(INDEX(B3:B9,MATCH(E1,C3:C9,0))=B3:B9,C3:C9))-E1

which must be confirmed with control+shift+enter instead of just with enter.

D3:

=IF(E3<>"",INDEX($A$3:$A$9,MATCH(ROW()-ROW($D$3)+1,$C$3:$C$9,0)),"")

E3:

=IF(ROW()-ROW($E$3)+1<=$E$1+$D$1,INDEX($B$3:$B$9,MATCH(ROW()-ROW($E$3)+1,$C$3:$C$9,0)),"")

Click to expand...

Okay, trying to follow all of this

=MAX(IF(INDEX(B3:B9,MATCH(E1,C3:C9,0))=B3:B9,C3:C9))-E1

Where B is my list of numbers (I need the top 20). But what is E1 and the C Range?

Click to expand...

Then for this to work do I need to rank my data first?

Click to expand...

Okay, so I am breaking this all down and appreciate the help.

However, when I try to rank my data, I am still getting duplicates.

If you take the Rank command and just rank the two cells (using your above example) for 23 ... both will return the same rank. One rank 23 is not higher or lower than the other rank 23, therefore the countif command is actually useless (since it is counting both 23's and subtracting 1, therefore it is a constant).

The problem is getting it to rank the first 23 as the 4th and the second 23 as the 5th. Am I getting a different result than yours or missing a step here somewhere? I believe that the rank command is the first step of the entire sheet.

Click to expand...