Hi All Members
i have this column in an sheet:

A
1 aminexcel
2 excelamin
3 stiglitzjoseph
4 josephstiglitz
5 markhamilton
6 hamiltonmark
7 hosseinobama

how can i recognize floating names with a formula or macro. i want to have this result

A B
1 aminexcel 1
2 excelamin 1
3 stiglitzjoseph 2
4 josephstiglitz 2
5 markhamilton 3
6 hamiltonmark 3
7 hosseinobama 4

any idea?