Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone have any suggestions on how to find out the first, second, and
third highest occurrence of number from a list? There is a sorted list of numbers in ascending order under column A, 3,3,3,3,3,4,4,5,5,5,6,6,6,6,6,7,7,9,9,9,10,10,10,1 0,10,11,11,11,11,11, 12,12,12,12,12,12 Since there is 6 occurrence for 12, and there are 5 occurrence for 3,6,10 Then it should return the 12 in cell B1, and 3 in cell C1, and 6 in cell D1, and ignore 10, because I would like to select the 3 numbers only from a list. Does anyone have any suggesitons? Thank in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pick highest number from a list | Excel Discussion (Misc queries) | |||
An add-in that allows you to find the highest prime in a number | Excel Discussion (Misc queries) | |||
Formula to find highest alphabetic name in a list of names | Excel Worksheet Functions | |||
i need a function to find the highest value in a list | Excel Worksheet Functions | |||
How do I find highest number in a row and change color? | Excel Worksheet Functions |