wins

  1. C

    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. A

    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. J

    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. J

    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. J

    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. M

    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. M

    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. D

    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. Ramballah

    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. T

    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. 6

    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. 6

    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. V

    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. K

    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. E

    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. L

    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. Y

    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. Y

    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. J

    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. T

    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"...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top