standings

I am producing a couple of league tables based on New sales figures and Used sales figures. I have the new side working perfectly however i am having issues with the formula for the used table. I have two worksheets. one called table, the other called Standings. Table has all my sales...

So I have a spreadsheet and I am trying to highlight the team name in the 2nd table, based on the next blank cell in the first table. What I am hoping for is that after i put in the score in table 1, it will change the highlight in table 2 to the next matchup. This will allow me to better see...

Hello, I was seeing if anyone would know any formulas or how to do a last ten games formula. Like a win-loss-ot loss. Also need a formula for a win/loss/ot streaks. Also if you have any other formulas please list for standings sheet. I have a sheet for the schedule and a 2nd for standings. I...

I know enough to know what a macro is, and can do some very, very simple ones. But I am trying to get to automatically update 3 sets of Conference Standings on the same worksheet (right side of picture). Any help would be greatly appreciated!

Hi Everyone, I'm trying to automate some statistics for my softball league, and one of the things I want to look at is opponent's Win-Loss record. I want to solve the problem using array formulas, but I can't seem to crack it. We have a table of home team/away team and another table of...

<tbody> Rank Player GP W L T PTS % W L W L W L GS GA +/- 2 Jessi 10 6 2 2 14 0.700 0 0 1 0 0 0 2 1 1 3 Dan 1 1 0 0 2 1.000 0 0 1 0 0 0 2 1 1 1 Fil 9 6 1 2 14 0.778 0 1 0 0 0 0 1 2 -1 </tbody> Rank is in Column A , (+/-) is in Column Q Jessi is in row 4, Dan is row 5, Fil is row 6...

A B C D E F G H I J K L M N O P Q <tbody> Rank Player GP W L T PTS % W L W L W L GS GA +/- 2 Jessi 10 6 2 2 14 0.700 0 0 1 0 0 0 2 1 1 3 Dan 1 1 0 0 2 1.000 0 0 1 0 0 0 2 1 1 1 Fil 9...

Good afternoon! I am hoping someone can help; I update a website for a state soccer league and am looking for a way to get standings to update automatically when I enter in the final score of that game. I find that having to update 2 different areas on the web site leaves a LOT of room for...