Re-generating incremental numbers

**razaas** · 09-05-2011, 03:01 AM

Help needed please, I want to have incremental number 1 2 3 ...... in column A but this should restart from 1 again if the value in column B changed, as below.

Please Login or Register  to view this content.

**arthurbr** · 09-05-2011, 03:17 AM

Enter the three first values - Copy the range -Select the range to copy to - Paste

**tone640** · 09-05-2011, 03:55 AM

If you have headers, in cell A2:

=IF(B2=B1,A1+1,1)

And fill down

**zbor** · 09-05-2011, 03:58 AM

try this: =COUNTIF($B$2:B2, B2)

What you expect if some number appear latter?
Check what this formula will retun. In case of number 7 it will continue at number 4

Please Login or Register  to view this content.

While above appraoch will return 1.

Please Login or Register  to view this content.

**razaas** · 09-05-2011, 04:13 AM

Tone640 & Zbor, Thanks a lot for such great help, not only my problem solved but also I learned two new formulas. As the number in ColB not going to repeat again later, therefore Tone640's formula is suitable. Thanks again and have a great day.