Numbering the column based on another column

[SHIGO]

HELLO,

i HAVE A DATA THAT LOOKS LIKE THIS,

10199751
10199751
10199751
10199760
10199760
10199765
10199765
10199765
10199765
10199765
10199765
10199765
10199765
10199777
10199777
10199777
10199777
10199777
10199777
10199777
10199777
10199780
10199780
10199780
10199780
10199780
10199780
10199780
10199789
10199789
10199798
10199798


THE RESULT I WANT IS

10199751 1
10199751 2
10199751 3
10199760 1
10199760 2
10199765 1
10199765 2
10199765 3
10199765 4
10199765 5
10199765 6
10199765 7
10199765 8
10199777 1
10199777 2
10199777 3
10199777 4
10199777 5
10199777 6
10199777 7
10199777 8
10199780 1
10199780 2
10199780 3
10199780 4
10199780 5
10199780 6
10199780 7
10199789 1
10199789 2
10199798 3
10199798 4


LIKE THIS I HAVE SOME 40,000 FILES AND I NEED TO NUMBER THEM AUTOMATICALLY.......BASED ON THE "A" COLUMN................HOPE SOMEONE HELPS ME WITH A MACRO

THANKS

[evertjvr]

If the sample data is in Column A
Here is the the formula that will help you.

Please Login or Register  to view this content.

Drag this formula down for as many rows as needed

you don't need a Macro

would you like still like a formula?

[jeffreybrown]

No need for a macro when you can use

Please Login or Register  to view this content.

Also, might want to get your caps lock key check it seems to be stuck...

[SHIGO]

Thanks guys.........

[jeffreybrown]

You are welcome. We are glad to have helped and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Sa DQ]

Please Login or Register  to view this content.