VB to Count till Change

[Mithmacil]

I don't do much with VB and need some help to count/tally up the number of instances of a given value.
Data is sorted by the value so all results are together just need a ongoing count till value changes or cell is blank
Value, Expected Result
23589, 1
23589, 2
23589, 3
23599, 1
23599, 2

 

[igold]

I have a question:

Looking at your example showing commas after the value and then the count, is it correct to assume that you want the data all in one column or is the data in one column and the count in the adjacent column. If it's two columns then what do you want done with the commas?

 

[Mithmacil]

The commas are to show a column separation. Data is in first column and count result would be the second column.

 

[igold]

How about just a simple formula. If your data starts in Cell A2 then cell B2 = 1 (assuming headers in Row 1). From that point in cell B3 and you could use

=IF(A3=A2,B2+1,1)

copied down column B.

 

[Mithmacil]

This is part of a much larger script i gave a very basic example as to not confuse what i was asking.