Apr 10 2021 11:14 AM
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?
Apr 10 2021 11:26 AM - edited Apr 10 2021 12:02 PM
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.
Apr 10 2021 03:16 PM
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) )
Apr 10 2021 11:26 AM - edited Apr 10 2021 12:02 PM
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.