In my spreadsheet column B represents a list of hundreds of names and what I would like to do is compile a list in column D which would represent each individual name that exists in column B and also the total number of times that name is lited in B.
For example :-
Column B could have the names
In this scenario columns D and E would output
The names in column B are not predefined and any name could exist.
I hope I have explained myself relatively clearly, and thank you for any help which is offered.