Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I extract a list of numbers missing in a list? | New Users to Excel | |||
getting the min and max of a list of numbers | Excel Discussion (Misc queries) | |||
how can I add +ve numbers only in a list of +ve and -ve numbers | Excel Discussion (Misc queries) | |||
change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) |