Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have some arrays like below: 29 5 26 4 24 4 23 3 24 3 25 5 24 3 23 3 24 3 27 4 27 5 25 2 27 4 26 1 For the above set, the most frequently appearing number for 24 is 3, the most frequently appearing number for 27 is 4, and so forth. i.e., I want to extract the most frequently appearing number for each number in the first column. This is what I want to get: 23 3 24 3 25 2 26 1 27 4 28 0 29 5 Thanks in advance. Herbert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to sum values extracted from string | Excel Discussion (Misc queries) | |||
how can the necessary information be extracted? | Excel Discussion (Misc queries) | |||
Formula That Totals Extracted Values | Excel Worksheet Functions | |||
Formatting Data being extracted from SQL D/B | Excel Programming | |||
How do I add a month to a filename extracted from a cell | Excel Programming |