| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count the frequency of all numbers in a column
I have a large column of numbers. I need to make a list of all the numbers
that are in that column and how often each appears. The result should be three columns: original unsorted number list, list of numbers found, how often each number is present in descending order. I've tried COUNT, COUNTA, FREQUENCY, INDEX, MATCH and just can't get seem to get it. Much thanks to anyone who can help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| Count based on another column | Excel Discussion (Misc queries) | |||
| Counting NUMBERS &/or TEXT from a column to other sheet ? | Excel Worksheet Functions | |||
| COUNT IF COLUMN X="" COUNT COLUMN Y? | Excel Discussion (Misc queries) | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Threaded Mode
