JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
I want to track the Vegas odds for the NBA playoff teams for the last few games of the season and through the playoffs. I have created a worksheet with tables like this.
<tbody>
</tbody>
This is the data for today. Tomorrow, when they update the odds after today's games, I want to add two new columns with those odds. The problem is that they sort it by the odds, so if the odds change, the order will be different. How do I add new data and get it pair up with the right teams?
The only solution I could come up with was to sort the table above alphabetically by team, then paste the new data complete with the team names and sort that the same way. Then I can delete the team name column for the new data and resort by the new odds.
Is there a better way?
PS: I have a UDF that will convert the odds between several different formats. If anyone would like it, I can post it.
| R/C | C | D | E |
| 3 | Team | Odds | Prob |
| 4 | Golden State Warriors | 6/5 | 45.45% |
| 5 | Houston Rockets | 8/5 | 38.46% |
| 6 | Cleveland Cavaliers | 15/2 | 11.76% |
| 7 | Toronto Raptors | 10/1 | 9.09% |
| 8 | Philadelphia 76ers | 25/1 | 3.85% |
| 9 | Oklahoma City Thunder | 50/1 | 1.96% |
| 10 | Portland Blazers | 50/1 | 1.96% |
| 11 | Boston Celtics | 55/1 | 1.79% |
<tbody>
</tbody>
This is the data for today. Tomorrow, when they update the odds after today's games, I want to add two new columns with those odds. The problem is that they sort it by the odds, so if the odds change, the order will be different. How do I add new data and get it pair up with the right teams?
The only solution I could come up with was to sort the table above alphabetically by team, then paste the new data complete with the team names and sort that the same way. Then I can delete the team name column for the new data and resort by the new odds.
Is there a better way?
PS: I have a UDF that will convert the odds between several different formats. If anyone would like it, I can post it.
