Auto-Numbering Occurrences Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I would like to automatically number the occurrences found in column A in
column B. For example:

A1: One B1: 1 (First occurrence of One)
A2: One B2: 2 (Second occurrence of One)
A3: One B3: 3 (Third occurrence of One)
A4: Two B4: 1 (First occurrence of Two)
A5: Two B5: 2 (Second occurrence of Two)

I am partially there using:
B1 =IF(A1<>"",COUNTA($A$1:A1)&".","")
B2 =IF(A2<>"",COUNTA($A$1:A2)&".","")
B3 =IF(A3<>"",COUNTA($A$1:A3)&".","")
B4 =IF(A4<>"",COUNTA($A$1:A4)&".","")
B5 =IF(A5<>"",COUNTA($A$1:A5)&".","")
but, I need to somehow add the conditional if A changes B restarts numbering
at 1. The file I'm going to copy into column A contains about 3,000
lines/rows.

Thanks for your help...


.

Relevant Pages

  • Re: Auto-Numbering Occurrences Question
    ... Biff ... >I would like to automatically number the occurrences found in column A in ... > 3,000 lines/rows. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Keeping 2 Excel workbooks open at the same time
    ... > and somehow my settings must have gotten modified. ... Dave Peterson ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Yankee Fans arent always baseball fans
    ... inferiority complex and that NY is still in their heads. ... (because the jagoffs don't realize that if they really wanted ... to somehow put NY down, ... Prev by Date: ...
    (alt.sports.baseball.ny-yankees)
  • Re: alternate row colors - NOT in a DB
    ... BTW this is also possible in CSS (somehow (on decend browsers)) or with ... clientside scripting. ... Prev by Date: ...
    (comp.lang.php)
  • Running Programs
    ... I did limit his user account, ... but somehow he managed to bypass that and put himself back on as ... Prev by Date: ...
    (microsoft.public.windowsxp.general)