User Profile
DerrellSC
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
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 different column. I would like for the count to automatically sort when the winner column is updated. /6.1KViews1like12Comments- 1.1KViews0likes0Comments
COUNTIF help
I have used COUNTIF several times before. But on this particular sheet it doesn't want to function. I am getting 0 when I should get 3. If i substitute "*" it counts all the cells. When I type out what (i.e. "Name") I'm looking for it works, but I have 6 sheets with 40 to 60 names to count on each. I did use a macro to generate a round robin tournament, but that is on a different sheet than the results. Any suggestions?1.2KViews0likes5Comments
Recent Blog Articles
No content to show