Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to choose the top two values from a column (preferably multiple
columns or an array). For example, if the column contains the numbers 1, 2, 3, 3, 4, 4, 5, 2, 5. I would like two have two cells below that column choose and display 5 and 5. Another example: column contains: 5, 7, 8, 7, 8, 7, 9, 8, 8, 12. Then the other two cells should display 12 and 9. Any help would be appreciated. P.S. The only values I'm dealing with are 0, 1, 2 and 3 so if you know of a workaround that would work with only 4 different values that would be fine. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
add only positive numbers and avg in a column | Excel Worksheet Functions | |||
need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
How do I get Excel to correctly add a column of numbers that have. | Excel Discussion (Misc queries) | |||
I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) |