count number in next column

[saravanan1981]

I have number in column C


as below

C=1 1
C=2 1
C=3 1
C=4 1
C=5 2
C=6 2
C=7 2
C=8 2
C=9 3500
C=10 3500
C=11 3500
C=12 3500
C=13 3500
C=14 4
C=15 4
C=16 4
C=17 4
C=18 4
C=19 4
C=20 878787
C=21 878787
C=22 878787
C=23 878787
C=24 878787
C=25 11
C=26 11
C=27 11
C=28 11
C=29 11

in column E i want the count for numbers in column at the end of the adjacent cells. please refer attachment. I have given my desired output in column E.

Please provide comments against each line of code to understand the function of the code

[AlKey]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

http://www.excelforum.com/excel-new-...in-column.html

[jeffreybrown]

Duplicate thread. Please continue in your original thread.