Numbering repeats in a column

**hbangalore** · 04-05-2012, 12:22 PM

Hi everyone,

I wanted to number the repeats in coulumn A as in the attachment. Any suggestions? If it put =IF(A1=A2...it shows a circular error and I do not know how to correct it

**bonny24tycoon** · 04-05-2012, 12:28 PM

Hi,

Check this out

If this helped PLEASE DO NOT FORGET to click the small star icon at the bottom left of my post.

**ron2k_1** · 04-05-2012, 12:35 PM

What about entering in B2:

=COUNTIF(A:A,A2)

And drag down as far as you like.

EDIT: Oh, sorry that's the same suggestion by the poster before me.

**hbangalore** · 04-05-2012, 12:46 PM

Hi thanks guys but it does not quite do what I want.

I want the repeats to be numbers as 1,2,3....etc. as posted in my excel sheet. This is because they are inturn connected to some values at different time points which i need to analyse.

**ron2k_1** · 04-05-2012, 12:51 PM

Then perhaps:

=COUNTIF($A$2:A2,A2)

There is limited info as to how you obtain your info, but the above will only count the occurrences up that that point and will not take into consideration the upcoming repeats. Can you tell me how you got the 2 in cell B12?

Ron