Listing top 3 numbers
 

Hello,
Need some advice on this one:

I've used the rank function to assess the top 3 numbers in a range of cells.
I'd like to enter a formula into a cell that lists the top 3 numbers.
Or if this is not possible, enter a formula into 3 cells:
Cell 1: Highest result
Cell 2: Second highest
Cell 3: Third Highest.

Thanks!
--
Excel Rookie

Listing top 3 numbers
 

How about ties?? If the values a

6
7
8
8
10
9
7
6
10
9

do you want 10,10,9
or
10,9,8
--
Gary''s Student - gsnu200789


"Excel Rookie" wrote:

Hello,
Need some advice on this one:

I've used the rank function to assess the top 3 numbers in a range of cells.
I'd like to enter a formula into a cell that lists the top 3 numbers.
Or if this is not possible, enter a formula into 3 cells:
Cell 1: Highest result
Cell 2: Second highest
Cell 3: Third Highest.

Thanks!
--
Excel Rookie

Listing top 3 numbers
 

Hey Gary,
From your example, I'd want 10,10, 9.

Would also like to see how 10,9,8 would work.

Thanks!
--
Excel Rookie


"Gary''s Student" wrote:

How about ties?? If the values a

6
7
8
8
10
9
7
6
10
9

do you want 10,10,9
or
10,9,8
--
Gary''s Student - gsnu200789


"Excel Rookie" wrote:

Hello,
Need some advice on this one:

I've used the rank function to assess the top 3 numbers in a range of cells.
I'd like to enter a formula into a cell that lists the top 3 numbers.
Or if this is not possible, enter a formula into 3 cells:
Cell 1: Highest result
Cell 2: Second highest
Cell 3: Third Highest.

Thanks!
--
Excel Rookie

Listing top 3 numbers
 

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

--
Gary''s Student - gsnu200789


"Excel Rookie" wrote:

Hey Gary,
From your example, I'd want 10,10, 9.

Would also like to see how 10,9,8 would work.

Thanks!
--
Excel Rookie


"Gary''s Student" wrote:

How about ties?? If the values a

6
7
8
8
10
9
7
6
10
9

do you want 10,10,9
or
10,9,8
--
Gary''s Student - gsnu200789


"Excel Rookie" wrote:

Hello,
Need some advice on this one:

I've used the rank function to assess the top 3 numbers in a range of cells.
I'd like to enter a formula into a cell that lists the top 3 numbers.
Or if this is not possible, enter a formula into 3 cells:
Cell 1: Highest result
Cell 2: Second highest
Cell 3: Third Highest.

Thanks!
--
Excel Rookie

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