Forum Discussion

Dumbass77's avatar
Dumbass77
Copper Contributor
Apr 10, 2021
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...
  • Riny_van_Eekelen's avatar
    Apr 10, 2021

    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.