Sequential numbers according to identical data

Hello everybody
I need to number the data as follows :
Yasser 1
Ahmed 2
Reda 3
Kamal 4

Hany 5
Yasser 1

Reda 3
Nader 6

Thanks advanced

I have found it
My data begins in A2 ..And the formula in B2

Please Login or Register  to view this content.

My request now how to convert this to vba code in worksheet change .. My range("A2:A20")

Any help about how to convert this formula to vba?

Try this:-

Please Login or Register  to view this content.

Regards Mick

Thanks a lot Mr. MickG
Thank you very much for this awesome code

You're welcome