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 | |||
Migrating Information | Excel Discussion (Misc queries) | |||
Migrating information into another sheet. | Excel Worksheet Functions | |||
Vlookups or Match to find multiple information | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) |