Forum Discussion

DerrellSC's avatar
DerrellSC
Copper Contributor
Feb 08, 2023

Sort function with countif?

Is it possible to sort 2 columns based on the second when the second is using counif?  I am tracking wins in a round robin badminton tournament and use countif to look for winner's names in a differe...
excel
DerrellSC's avatar
DerrellSC
Copper Contributor
Feb 22, 2023

Here is one of my Round Robin tournaments.  As I update the winners in the column, it does count, but can it automatically sort the column without creating and additional "ranking" column?

Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 22, 2023

DerrellSC 

Perhaps this one:

 

=LET(uWinner,UNIQUE(TOCOL(winner,1)),k,ROWS(uWinner),stack,HSTACK(uWinner,COUNTIF(winner,uWinner)),HSTACK(SEQUENCE(k),SORT(stack,2,-1)))
  • DerrellSC's avatar
    DerrellSC
    Copper Contributor
    Feb 27, 2023

    Patrick2788 Thank you, but I don't want to add another set of data.

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Feb 27, 2023
      I think you've misunderstood my solution. It's not adding another set of data. It would replace what's already there.
      • DerrellSC's avatar
        DerrellSC
        Copper Contributor
        Feb 27, 2023

        Patrick2788 Ok, but as I fill in the winner's column it gives me a #NAME error for those columns.

Resources