Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find all same numbers in a column without dropdown listing | Excel Worksheet Functions | |||
listing all numbers in range eg 13-87 | Excel Worksheet Functions | |||
listing top to bottom. | Excel Discussion (Misc queries) | |||
sum and listing | Excel Discussion (Misc queries) | |||
Listing the links | Excel Discussion (Misc queries) |