# wins

1. ### SUMIF with INDEX MATCH Issue

I have the following data: <tbody> A B C D E 1 Team 1 1 Team 2 2 2 Team 3 2 Team 4 1 3 Team 1 1 Team 3 2 4 Team 4 1 Team 1 2 5 Team 2 2 Team 1 1 6 7 Team 1-Wins Team 1-Losses </tbody> Whenever a team wins, a 1 is entered manually into Column B or Column D...
2. ### Wins + Losses for Sports Teams at Different Points

Hi all, First time posting and looking for some help regarding a set of sports statistics. I am looking to analyze the effect of home court advantage in the 2018-2019 season and wanted to be able to control for how many wins each team has at a certain time in the season. I currently have a set...
3. ### Locating a value based on column header name instead of Column Number

Hello there, I am looking for a formula that can handle returning an index value based on header names instead of index number. This is because the data source is dynamic. The location of the index value I am looking for will vary depending on the source. There are two reliable constants...
4. ### How to compare common opponents

I have been lurking for a while, reading a lot of great questions and answers! I could use some help that is a little above my excel pay grade: I am looking to compare two or more college wrestlers against common opponents. Results are posted in a dual-meet format so: 125 lbs wrestler 1 dec...
5. ### Calculating total sums based on other cells

I thought I had this figured out, but it's doing my head in now! I'm trying to calculate the total value of WINS only. Can anyone help? Thank you.
6. ### Single line graph different colours

Hi all, I have 2 criteria, and based on which one is rtue I would like the colour of a line on the line graph to change. I am doing this for points in a tennis match to show the momentum changes. If Roger Federer wins the point the line graph goes up by 1, is Novak Djokovic wins a point the...
7. ### Line graph with different colours depending on criteria

Hi all. I am looking to use a line graph to show momentum changes in a tennis match. I have a column showing momentum change ( +1 whenever player A win's a point and -1 when player B win's the point). I have then used an IF function so show when player A wins the point but show NA () when...
8. ### Creating a Volleyball League Schedule

Hello experts, I am trying to create a volleyball league schedule on excel where I can place scores(I14:I17, K14:K17, Q14:Q17, S14:S17) that automatically calculate and update the cells that show the standings (E2:E9, F2:F9). A B C D E F...
9. ### Saving old values with VBA?

Hello everyone, I have an issue. I have made a chart for a game im playing. when i win a match i will type in W and it will automatically show me how much money i made with the use of IF functions. if i put in an L it will do for losing. like this: https://ibb.co/gcBD2U As you can see i have...
10. ### What can serve me best Excel or Access

Hi all I am trying to build something to use for my local darts and dominoes league and are unsure which one is best for what I need and am looking for help. I have downloaded some football spreadsheets from internet where you enter the score and it updates the league but our league is based...
11. ### A simple game is driving me crazy... need help with a counting function.

I have tried to simplify this in my small brain and try to present it to this forum in a manner which respected their time (and solicited a quick/ easy answer). But when I try to simplify, I lose the challenge. Basically I am confusing myself. Is there anyone who could take a look at this and...
12. ### formula(s) to count points that "carry-over" or build if not won... then drop back to 1 after a win??

I had a hard time thinking of a good title for this since it is hard to explain. here is what I am hoping to achieve... There are four individual games that are each worth a point. If someone wins the game, then they win 1 point. If nobody wins the game, then that point "carries over" and...
13. ### Summing Largest Consecutive Dollars and Consecutive Average Question

Hello, I would like to know how i could sum the most consecutive wins in dollars in column A, and the average consecutive wins in column B. In the table below, you can see in column A1:A3, three consecutive dollar wins which should total \$43. How do i go about calculating the largest sum in...
14. ### Last 10 Game Wins

Upon search I have found https://www.mrexcel.com/forum/excel-questions/830707-calculating-current-streak-record-last-10-games.html but I cannot get it to work like it is written. Upon edited many time all I could ever get it to do was show 10W all the time. I too have a sheet (Sheet1) with a...
15. ### Horse Racing - Win Probability/Place Probability

Hi All, I am looking for assistance for a mathematical formula to be able to turn my assessed win betting prices (win %) into place betting probabilities. The below should explain the equation a little further. <tbody> W% 2nd % 3rd % Horse 1 35 Horse 2 15 Horse 3 13 Horse 4 10...
16. ### Count consecutive wins

Hello. I want to count the number of consecutive wins in a table. Below I have an example. <tbody> \$40 -\$20 \$25 \$10 \$5 \$41 \$32 -\$5 \$9 -\$12 </tbody> My goal is to be able to count how many consecutive wins I was able to get. The example shows 4 consecutive wins <tbody>...
17. ### Ranking with Multiple tiebreakers

Good evening, I'm looking for some help. I created a workbook, that has functions across sheets and tables(2). I created this book before I actually had any training in excel, and that was only an intro. It may seem a bit amature, but it is functional. I would like to make even more so, by...
18. ### Pool match results – counting player wins and losses in an array.

The pool Match consists of 7 games and the 4th game is always a doubles game. Teams must have at least 6 players so 2 players could play a doubles game as well as their singles game. Please refer to the spreadsheet link. There are two tables, one for fixture and results details and the other for...
19. ### Win-Loss by League

So I am trying to track wins, losses and ties and by a certain league/team. <tbody> Result Team W A Team A W's L's Tie W B W C Team B W's L's Tie L A L A Team C W's L's Tie W B L B W C L C </tbody> So I want it to look at the result in Col A, then...
20. ### 4 Formulas in a 2x2 Table to Calculate the total Wins & total Losses for both Buys and Sales

Hey my fellow celly nerds, I'm wondering if you can help out. I need 4 simple, but related formulas. I uploaded a screenshot of the first page of my data here for you to quickly glance at first, if you would. http://we.tl/1n6sJdBRot It's just a wetransfer.com link, since there's no "browse"...