Label/Reference the repeated values

[HTBC19]

Hi,

Struggling to find a way of doing this so I'm open to suggestions!

[TABLE="width: 111"]
<tbody>[TR]
[TD]IR1.2.3[/TD]
[/TR]
[TR]
[TD]IR1.4.5[/TD]
[/TR]
[TR]
[TD]IR1.2.3[/TD]
[/TR]
[TR]
[TD]IR1.2.3[/TD]
[/TR]
[TR]
[TD]R15[TABLE="width: 111"]
<tbody>[TR]
[TD]IR1.4.5[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

The above is a sample list of references I'm usually working with, what I need to do is put in the column to the right the a label/reference to show the cumulative times a reference has occurred, from top to bottom, so it would look something like the below:

[TABLE="width: 222"]
<tbody>[TR]
[TD]IR1.2.3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]IR1.4.5[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]IR1.2.3[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]IR1.2.3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]R15[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]IR1.4.5[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

I'm open to any and all solutions whether it be a formula or something in VBA.

Thanks

 

[FormR]

Hi, welcome to the forum!

Here is one option.

Excel 2013/2016
	A	B
1	IR1.2.3	1
2	IR1.4.5	1
3	IR1.2.3	2
4	IR1.2.3	3
5	R15	1
6	IR1.4.5	2
Sheet1

Cell Formulas
Range	Formula
B1	=COUNTIFS(A$1:A1,A1)

 

[HTBC19]

Thanks, that's just what I was after!