Help need in VBA code for finding repeated data count number in excel?

[yugeshkumar]

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.

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.

[dangelor]

Not sure what you want in steps 3 & 4, but this will give you the numbers and count...

Please Login or Register  to view this content.

[yugeshkumar]

working fine thanks.

[dangelor]

You're welcome. Glad I could help!