I’ve tried a bunch of formulas and various table structures and just can’t seem to find a way to get what I need.
So let’s say I’m running a kids soccer league, or an e-sport, or really anything close. In other words I have games:
Celtics Win - Pacer...
Hah. And yes, I definitely know how to do this in excel with a very long IF statement. In case it gets your brain firing here’s my statement in excel right now (though it does this and a whole lot more).
=IF(’#Matchups (St)’!G9="","",IF(AND(‘Total Ma...
Just for explorations sake, how would you do it explicitly?
Generally of course I’m not looking to generate the result once, but in a formulaic way so you can work your way through all the matchups. If there’s a manual way to do it then, theoreticall...
yeah you are right, it’s pulling the data you would want, just in an incredibly hard to digest format.
The database function would just be allowing you to reference a count against a combination of elements, instead of a single element (if “team a” a...
Pivot Table blocks are getting closer to what I need, for sure. They can’t really display the necessary information though.
The default is Count - which would just be the number of games played, not the W/L record. There’s no way to reference the Piv...
