Started By
Message
re: College Basketball Program Rankings
Posted on 4/9/24 at 11:15 am to paperwasp
Posted on 4/9/24 at 11:15 am to paperwasp
quote:
Do you have 85 columns of calculated values for some 330-odd teams?
I have about 150 teams’ NCAA history uploaded into a master spreadsheet. I have some XLOOKUP factors and a giant pivot table that allows me to filter by team and by year.
This post was edited on 4/9/24 at 11:17 am
Posted on 4/9/24 at 11:27 am to AUTiger789
quote:
XLOOKUP
Nice way to do it.
That was essentially where I was going with this, whether you had it in a spreadsheet or a database queried directly through code.
Sounds like a little bit of both, depending on the variables in your cells.
Would be cool to see one of those animations of someone's (like the SEC's) charted rankings over time.
Posted on 4/9/24 at 11:59 am to AUTiger789
quote:
I have about 150 teams’ NCAA history uploaded into a master spreadsheet.
Popular
Back to top
Follow SECRant for SEC Football News