counting names

mani_singh

Well-known Member
Joined
Jul 24, 2007
Messages
583
hi,

i have a list of names (including duplicates) in column B - B2:B2000

what i need is a macro which copies the only the unique names into column I but i also need the number of time that name appeared in column B put along side it in column J.

E.G.

COLUMN B
jim
jim
jim
jack
dave
jack
jim

GIVES

COLUMN I | COLUMN J
jim 4
jack 2
dave 1



thanks!
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Hi,

Do you really need a macro?

You can use advanced filter to create the list of names leaving the criteria blank and selecting the Unique Records Only option. Then a COUNTIF formula would give you the count you require.

Dom
 
Upvote 0

mani_singh

Well-known Member
Joined
Jul 24, 2007
Messages
583
fair comment! now why didn't i think of that..... appoligies going to try it now. thanks however i'll shout if i need some help. thanks again
 
Upvote 0

Forum statistics

Threads
1,190,808
Messages
5,983,038
Members
439,815
Latest member
yoswosz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top