Listing top 3 numbers
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
|