How to sort names by times they appear

Occasional Visitor

So I have a large sheet with a record of when we tested people.  What day and who.   I've sorted it by the names so that at least they appear together if they are repeats, but I'd like to now sort it by the highest number of repeats - so IE the person we've performed the most tests down to the least.   


How do I do that please?

2 Replies
best response confirmed by Dumbass77 (Occasional Visitor)

@Dumbass77 Since you tagged your post "Office 365", your Excel version might support Dynamic arrays and the UNIQUE function. If so, the attached file contains a solution that may work for you.




If it is the original table that you need to sort, this can be done with the formula

= LET(
  count, COUNTIFS(Names,Names),
  SORTBY(Table, count,-1) )