Hello

Can anyone help me out with some vba code? I think I may need an array but a little unsure on the best way to go about it.

In column A I have a list of peoples surnames

example:-
jones
smith
patel
jones
jones
grey
patel
chu
jones

I need the script to generate something like this (into a string? or even into a spare worksheet) - picking up every new unique name and counting the times it appears in a column

jones 4
smith 1
grey 1
patel 2
chu 1

Would anyone be able to help?

thanks

Mark