Top 3 numbers in a list
 

Howdie... :)

Cells a1: a10 have numbers in them between 1 and 4
I want to know what the top 3 max numbers are

eg a1 = 3, a2 =3 a3 = 2 d3 to d10 = 0 then top 3 are 3, 3, 2

eg 2 if a1 = 3 and a2 to d 9 = 0 then only one max would be 3

eg if a1 = 2 b2 =2 c2 = 2 d1 = 1 c1 = 0, then top three max would be 2,
2 and 2.

ANy ideas...
(countif would work but seems to take a long time to write the formulae
to exclude the previous results....

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Top 3 numbers in a list
 

Hi Darin,

In Cell A12 Use Formula =LARGE(A$1:A$10,1)
In Cell A13 Use Formula =LARGE(A$1:A$10,2)
In Cell A14 Use Formula =LARGE(A$1:A$10,3)

HTH
All the Best.
Paul



Darin Kramer wrote:
Howdie... :)

Cells a1: a10 have numbers in them between 1 and 4
I want to know what the top 3 max numbers are

eg a1 = 3, a2 =3 a3 = 2 d3 to d10 = 0 then top 3 are 3, 3, 2

eg 2 if a1 = 3 and a2 to d 9 = 0 then only one max would be 3

eg if a1 = 2 b2 =2 c2 = 2 d1 = 1 c1 = 0, then top three max would be
2,
2 and 2.

ANy ideas...
(countif would work but seems to take a long time to write the
formulae
to exclude the previous results....

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!