How to Give serial numbering to Group of Duplicate values ?

[navinrb]

How do i give numbering to each bunch of duplicate values
Eg : 3471113 as 1
3471116 as 2
3471117 as 3 and so on
As shown in figure... I can count duplicate usung countif but want to number those duplicates too ..thanks for reading

 

[sandy666]

like this?

Raw		Result
3471113		3471113.01
3471116		3471113.02
3471117		3471113.03
3471113		3471113.04
3471119		3471116.01
3471113		3471117.01
3471113		3471119.01

use XL2BB to post representative example of source data and expected result (not a picture)

 

[navic]

Listen to the advice of colleague @sandy666
You are not clear enough for me.
You should have set an example of the expected results.

Try one of these two formulas below
in the 'X2' cell (copy down)

=R2&"."&COUNTIF(R$2:R2,R2)

or
in the 'Y2' cell (ARRAY formula, finished with CSE), (copy down)

=IF(COUNTIF(R$2:R2,R2)=1,MAX(Y$1:Y1)+1,INDEX(Y$1:Y1,MATCH(R2,R$1:R1,0)))

 

[navinrb]

like this?

Raw		Result
3471113		3471113.01
3471116		3471113.02
3471117		3471113.03
3471113		3471113.04
3471119		3471116.01
3471113		3471117.01
3471113		3471119.01

use XL2BB to post representative example of source data and expected result (not a picture)

Sorrythat's not my desired result. I want to give serial numbering to group of duplicate values like 1 for all duplicates 371113 and 2 for all 371116 ...so on...

 

[navinrb]

Listen to the advice of colleague @sandy666
You are not clear enough for me.
You should have set an example of the expected results.

Try one of these two formulas below
in the 'X2' cell (copy down)

=R2&"."&COUNTIF(R$2:R2,R2)

or
in the 'Y2' cell (ARRAY formula, finished with CSE), (copy down)

=IF(COUNTIF(R$2:R2,R2)=1,MAX(Y$1:Y1)+1,INDEX(Y$1:Y1,MATCH(R2,R$1:R1,0)))

Thank you i will try this one. Hope it works