Count the Repeating data

[amiable]

Hi,

Please find the attachment, this sheet will copy the repeating names are store in another sheet.
I need macro for Names are repeating in how many times, this information store into sheet2.

Please help me.

Example:
Resource CPQ

G,Gopalakrishnan 5
Kakumanu,Sudhakar Reddy 10
Kamisetty,Kalyana Varadarajulu 27
Khan,MohammedBilal 15
Kulat,Sharad 15
Kushwah,Vikas 21

Thanks

[Richard Buttrey]

Hi,

C4 copied down

Please Login or Register  to view this content.

[amiable]

Can you provide me through macro.. because , if i click the button, Name and how many times Names are repeating information should copy to sheet 2.

[Richard Buttrey]

Hi,

Why do you need the macro? Are you saying that the sheet 'Disturbution' doesn't exist and you need a macro to create it. If it does exist why can't you use the function I gave you?

[Winon]

Hi amiable,

If you want to use VBA to add the formula Richard Buttrey gave you, then add this bit of code to the Bottom of your Calculation Module:

Please Login or Register  to view this content.

[amiable]

Thanks Winon, Its working fine....