Forum Discussion
Solved
How to sort names by times they appear
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...
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) )