Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting identical items in a column and returning the occurrences
I use excell 2000. I have one column with 700 rows. In each cell is one
number, either a 0, 1, 2, 3, 4, or 5. In the second column I have five rows, each with one number in increasing order: 0, 1, 2, 3, 4, 5. Next to the numbers 0-5 (in column three) I want the total number of occurances for each number in column one. So out of the 700 rows, if the number 2 occurred 230 times, I want the number 230 to show in column 3 to correspond to the number 2 in column two. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting items in one column based on criteria in another column | Excel Worksheet Functions | |||
Counting items in one column based on criteria in another | Excel Worksheet Functions | |||
Counting different items in one column | Excel Discussion (Misc queries) | |||
Counting occurrences in one column based on an occurrence in anoth | Excel Worksheet Functions | |||
counting similar items in a column | Excel Discussion (Misc queries) |