| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count quantity of repeated items in a column
I have a list that contains numbers that repeat Example: 900,825,827,900,
765,827,765, 765, 902, 900, etcc... I want to know how many times each number is repeated in that column. What function in Excel 2007 do I use so that I know 900 was repeated 340 times and 825 was repeated 23 times. There are thousands of numbers repeated thousands of times so how do I found out how many times each number is repeated? Can someone explain this step by step because Im new to Excel... Thanks, Susan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count like items (words) in a column? | New Users to Excel | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| How do I sort - and count - items in a column? | Excel Discussion (Misc queries) | |||
| How do I count the items in one column if another column is blank | Excel Worksheet Functions | |||
| Count number of items in one column that have a value in another? | Excel Worksheet Functions | |||
Threaded Mode
