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