If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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 05 (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? 
Ads 
#2




counting identical items in a column and returning the occurrences
Try this:
In C1 (to count the zeros) =COUNTIF($A$1:$A$701,"0") In C2 (to count the 1s): =COUNTIF($A$1:$A$701,"1") etc. Hope that helps. If it does, rate it has helpful at the bottom of the post. "ExcelWizardImNot" wrote: > 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 05 (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? 
#3




counting identical items in a column and returning the occurre
That did it. Thanks much.
"Huber57" wrote: > Try this: > > In C1 (to count the zeros) > > =COUNTIF($A$1:$A$701,"0") > > In C2 (to count the 1s): > > =COUNTIF($A$1:$A$701,"1") > > etc. > > Hope that helps. If it does, rate it has helpful at the bottom of the post. > > "ExcelWizardImNot" wrote: > > > 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 05 (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? 
#4




counting identical items in a column and returning the occurre
In order to avoid the correction of each and every formula  in your private
case  I would suggest, in cell C1 to type the following formula and copy down till C6: =COUNTIF($A$1:$A$700,Row()1) Micky "ExcelWizardImNot" wrote: > That did it. Thanks much. > > > "Huber57" wrote: > > > Try this: > > > > In C1 (to count the zeros) > > > > =COUNTIF($A$1:$A$701,"0") > > > > In C2 (to count the 1s): > > > > =COUNTIF($A$1:$A$701,"1") > > > > etc. > > > > Hope that helps. If it does, rate it has helpful at the bottom of the post. > > > > "ExcelWizardImNot" wrote: > > > > > 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 05 (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  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Counting items in one column based on criteria in another column  luttona  Excel Worksheet Functions  3  June 13th 08 06:00 PM 
Counting items in one column based on criteria in another  kmc103  Excel Worksheet Functions  4  May 15th 08 09:17 PM 
Counting different items in one column  Chris  Excel Discussion (Misc queries)  2  March 23rd 06 10:08 PM 
Counting occurrences in one column based on an occurrence in anoth  Jim Jackson  Excel Worksheet Functions  12  March 4th 06 12:10 AM 
counting similar items in a column  bj  Excel Discussion (Misc queries)  5  June 6th 05 10:30 PM 