counting names

[mani_singh]

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!

 

[Domski]

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

 

[mani_singh]

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

 

[mani_singh]

done, thanks dom, silly question simple answer