Here's one method. In C1 use your existing formula for
the largest number:

=LARGE(A1:A10,1)

In C2 use this formula (array-entered, meaning press ctrl
+ shift + enter), then fill down:

=LARGE($A$1:$A$10,SUM(COUNTIF($A$1:$A$10,$C$1:C1)) +1)

HTH
Jason
Atlanta, GA

-----Original Message-----
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!
.