I have an excel spreadsheet with 5 columns of data. Column two contains names. I would like to order the sheet in descending order of who has the most number of occurances of their name.
How could I do this?
I thought of putting a number in front of the name to specify the order in the list but the list changes as items are added and manually changing each number as things change order is not appealing.