Forum Discussion
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...
I think you've misunderstood my solution. It's not adding another set of data. It would replace what's already there.
Patrick2788 Ok, but as I fill in the winner's column it gives me a #NAME error for those columns.
- Do you use office 365?
do you mind online tool?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.
- 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;
