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!!
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!!
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R1 | 1100m | Mdn | 10 |
R2 | 1300m | Mdn | 6 |
R2 | 1300m | Mdn | 6 |
R2 | 1300m | Mdn | 6 |
R2 | 1300m | Mdn | 6 |
R2 | 1300m | Mdn | 6 |
R2 | 1300m | Mdn | 6 |