Hi,
And to get 10, 10, 9 in a single cell:

=LARGE(A1:A10,1)&", "&LARGE(A1:A10,2)&", "&LARGE(A1:A10,3)

Regards - Dave.

"Gary''s Student" wrote:

To get the 10,10,9:


In cell B1 enter:
=LARGE(A1:A10,1)
In cell B2 enter:
=LARGE(A1:A10,2)
In cell B3 enter:
=LARGE(A1:A10,3)


To get 10,9,8:

In cell C1 enter:
=MAX(A1:A10)
In cell C2 enter:
=MAX(IF($A$1:$A$10<C1,$A$1:$A$10)) as an array formula
In cell C3 enter:
=MAX(IF($A$1:$A$10<C2,$A$1:$A$10)) as an array formula