VBA to count number in column and give number sequence in next column

[saravanan1981]

I have number in Column B in sorted by ascending order. some numbers are unique and some numbers are duplicate. In example I have given maximum duplicate of 3 but in actual duplicate may go upto 10 times
I want give number with extension (number of existence) in Column C. Please refer attachment . My data type and desire result mentioned


For Example

Row Number two there is a number 5 in column C and it is exist only one time. Hence Existence Given as 1 i.e. 5 Exist 1st time
Row Number three there is a number 8 in column C and it is exist only one time. Hence Existence Given as 1 i.e. 8 Exist 1st time
Row Number four, five and six there is a number 55 in column C and it is exist three time. Hence Existence Given against respective numbers as as 1 i.e. 55 Exist 1st time, 55 Exist 2nd time, 55 Exist 3rd time
Row Number Eight and nine six there is a number 60 in column C and it is exist two time. Hence Existence Given against respective numbers as as 1 i.e. 60 Exist 1st time, 60 Exist 2nd time

Note: In example I have given maximum duplicate of 3 but in actual duplicate may go upto 10 times: So the result should be exist 8th time, 9th time, etc.

[Olly]

You could use the formula:

Please Login or Register  to view this content.

in C2, and copy down.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.