Serial number

[durga_ikon]

If the data is in col
1
2
3
4
1
2
i want a formula in the right cell of each col, o display the number of time data is repeating in sl wise

like this

1-1

2-2

33-1
33-2
33-3
33-4
34-5

[durga_ikon]

A sample attached

[tom1977]

try this
=countif($A$2:$A3,A$2:A3)

[durga_ikon]

THANKX A TON TOM

[zbor]

try this
=countif($A$2:$A3,A$2:A3)

tom, that's same as: =COUNTIF($A$2:$A2, A2)

[tom1977]

Now I know why it looked so strange