Macros - adding number to specific names

Hi,
i want to make a macro, that adds numbers in order from 1 to the end of the list, but for the same name, the same number. I have added an example in link bellow.
Can anyone please help me find the solution? Sorry about my bad english. If you need additional informations, just say.

http://shrani.si/f/14/Ev/2SDFCx1q/tabel.jpg

I appreciate for any help in advice.

Are you wanting to reuse this macro or just have it create the numbers on some worksheet you're using? if its a one off then in Column A add the following into A2
=if(B2=B1,A1,A1+1)

then drag it down the length of your sheet.

Please explain your query in attached sheet

I need to use this macro on different worksheets, few times a month. I have tried with =if(B2=B1,A1,A1+1) but it`s not working or I didn`t make it right. It says: The formula you typed contains an error.

Kamboj
I manually insert a column A, than I need to insert numbers in column A. Each name in column B must have the same number. The numbers must be created in order. The lenght of the list is every time different.

the formula is correct, I forgot to mention that in A1 you should put the number 1 so that A2 knows what to do next.

I stil can`t figure it out, what am I doing wrong :S
First row is header row, so I put number 1 in A2. than I put =if(B2=B1,A1,A1+1) in A2?
Sorry for confusion.

My bad.

In A2 put the number 1
In A3 put the formula =if(B3=B2,A2,A2+1)

Double click the bottom right of Cell A3 to populate all the required cells below or drag the cell down as far as you need.

I still get an error message. And I did exactly like you said.
In A2 put a number 1, in A3 put if formula, hit enter and get the error message.

can you add your spreadsheet to this so I can see it? what exactly does the error say?

What I did:
http://shrani.si/f/c/kY/dVDj8CR/1.jpg

Error message:
http://shrani.si/f/17/Kq/4Bc7Eys6/2.jpg

I have to admit Im lost, that definitely looks correct and Ive just tested the formula and it works fine here. Can you create a new sheet with just a dozen or so test items in and apply the formula there to see if its something to do with the workbook itself?

Ok I think I finally did it! Instead of , you have to put ;


Thanks again for all you help!
Take care

very strange because you definitely have to use , in an IF statement?