Forum Discussion
DerrellSC
Feb 03, 2023Copper Contributor
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 ou...
DerrellSC
Feb 03, 2023Copper Contributor
Thank you. I have no idea how the space got in there. Works Great!
DerrellSC
Feb 08, 2023Copper Contributor
Now is possible to have the wins sorted descending automatically as the wins change?
- HansVogelaarFeb 08, 2023MVP
You could use the SORT function to return the wins in descending order in another range.
If you want the wins to be sorted automatically in place, that would require VBA (which works only in the desktop versions of Excel for Windows and Mac , not in the online, Android and iOS versions).