count duplicates in column

Hi,

I want to create a macro that displays the index number of duplicates of column A in column B. So one column after the second "abraham" should display "2", one column after the third "abraham " should display "3", etc.

Any input is much appreciated!