Formula to Total the number of instances

Beddy Boy

New member
Joined
Feb 1, 2017
Messages
48
Reaction score
0
Points
0
Excel Version(s)
Excel 365
I wonder if anyone can help.

I have a spreadsheet with 3 columns of data. I wish to add automatically to each cell in the 4th column the number of instances that the value in col 1 occur.

For instance in col 4, the number 10 is placed for all the R1s (as there are 10 instances of R1) and then the number 6 for R2.

Many thanks!!

R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R11100mMdn10
R21300mMdn6
R21300mMdn6
R21300mMdn6
R21300mMdn6
R21300mMdn6
R21300mMdn6
 
Thanks Alan!!
 
Last edited:
Unfortunately though I have 13500 rows.

The count I am getting is way bigger than it should be. The reason for this is that R1, R2 etc are repeated further down the page in my sheet. Therefore the result of R1 is 1500. Is there any way I can just limit the count to each "block"?

Wayne
 
Back
Top