SOLVED

How to sort names by times they appear

Copper Contributor

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 (Copper Contributor)
Solution

@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.

 

 

@Dumbass77 

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) )

 

1 best response

Accepted Solutions
best response confirmed by Dumbass77 (Copper Contributor)
Solution

@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.

 

 

View solution in original post