Superfluous columns... See Harlan's reply.

Aladin Akyurek wrote:
One way...

Let A2:A11 house the sample you provided.

B1: I-Rank

B2, copied down:

=IF(ISNUMBER(MATCH(A2,$A$1:A1,0)),"",RANK(A2,$A$2: $A$11))

C1: F-Rank

C2, copied down:

=IF(N(B2),RANK(B2,$B$2:$B$11,1),"")

D1: List

D2, copied fown:

=IF(ROW()-ROW(D$2)+1<=5,INDEX($A$2:$A$11,MATCH(ROW()-ROW(D$2)+1,$C$2:$C$11,0)),"")


Master wrote:

Hi!

I'm currently using the LARGE function to return the top 5 numbers in
a set of cells. Now the problem is that the formula sometimes returns
the same value. Example

A
20
55
85
75
15
65
75
75
35
95

On the sample above, below formula returns the top value as:
=LARGE(a1:a10,{1}) ... {2}, {3} and so on..
top 1 = 95
top 2 = 85
top 3 = 75
top 4 =75
top 5 =75

What i want to happen is for the formula not to return the same value
if it's already on the other top numbers.

Is there any way to do that?

Pls help, thanks so much!