| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
frequency a number repeats in a column
I have a spreadsheet that is 8 columns by 1000 rows. each cell contains a
number from 1 to 100. I need to find out which numbers in each column repeat the most often, then the next most frequent. I thought that the frequency command would do it but I can't make it work on my data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =sum(A:A) add to column (B) and new value repeats w/ new sums | Excel Worksheet Functions | |||
| How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
| function for finding repeats in a column... | Excel Worksheet Functions | |||
| How do I count the frequency of a given number in a column? | New Users to Excel | |||
| no repeats in a column | Excel Worksheet Functions | |||
Threaded Mode
