Vba code need find a duplicate value counts

Hi

I m having address book details in Column A
Address book contain the following details

Name :
Address :
Blood group :
Mobile : (123456789)
etc..
like as n number of values. Excel attached

step1-I wants to extract the all mobile number value like (123456789) to column B
step2-using that column B value repeated numbers count number should entered in column C (ex: 1,2,3)
step3-two times repeated mobile number copied in column D2, three times repeated mobile number copied in column E2
step4- column D & E should have only unique values.

In Cell b3 I put the following formula:

Please Login or Register  to view this content.

. I'm not sure I understand what you want after that. If in your example, you could show how the results would look (on another tab) this would be useful to help you out. Please reAttach worksheet with END results.