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
peiyezhu's avatar
peiyezhu
Bronze Contributor
Feb 28, 2023
Do you use office 365?
do you mind online tool?
DerrellSC's avatar
DerrellSC
Copper Contributor
Mar 01, 2023

peiyezhu it is office suite 2016, nit sure if that is 360 or not.  I don't want it to be more complicated than me having to hit the sort function at the end of each session.

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Mar 06, 2023
    I am not sure if it is complicated.
    if possible,try below online tool.
    http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=rank_winner
    create temp table aa as
    select WINNER name,count(WINNER) wins from rank_winner_of_Round_Robin_tournaments where WINNER!='' group by WINNER order by count(WINNER) desc;
    select rowid,* from aa;
  • bosinander's avatar
    bosinander
    Steel Contributor
    Mar 05, 2023

    Hi DerrellSC 

    Choose Insert: Table to create a "pyamas table" and enter the participants names in one column.

    Next column, a formula that counts the number each name is found in the winner column. The formula will be a column formula and expands automatically with the number of names.

    =COUNTIFS(G:G,[@Name])

    Use the tables sort function in the drop down menu in, below, cell B1.

    Excel 365 is only available as subscription and continuously updated with new great features. With 365 the Round Robin-generator some answers above could be created without macros. The one attached here is without any features except countifs.

    2301 means update version january 2023.