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.
Bookmarks