I'm working in Excel spreadsheet exported from a Sharepoint survey solution. The spreadsheet contains names of the people from the survey in a table.
There are multiple duplicates in various cells within this table.
I am trying to do the following:
1. Sort the names in Alphabetical order
2. Count the number of names
3. A tally of Names with number of duplicates (if possible)
Is there a tool or formula that I can use to achieve this? A sample of input data and also what I would like to achieve as an output is attached.
Thanks in advance!