game

  1. C

    sum column of numbers based on id # and other possible criteria

    I am trying to do the following but cannot seem to wrap my head around it. I have a workbook with multiple sheets. For what I am doing I have to pull information from one and compare it to another. It looks something like this: Sheet 1 <tbody> A B C D E F 1 Game # Cards Home ID Home...
  2. J

    searchable dropdown list with exchangeable names

    Hello, I did a list as suggested here : https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/ It works very fine. However, I would like to improve it for my needs. My list in column F contains cell with many words, separated by a coma : “,” Example : F3 : house, cat, hospital...
  3. Y

    Get first argument for INDEX from calculated column plus one other question

    I use a formula such as =IF(ROWS($1:1)>COUNT($A$5:$A$1840),"",INDEX(Games!E:E,SMALL($A$5:$A$1840,ROWS($1:1))+4)) to retrieve the value for a given column/row based on the selection from =IF('Analysis Data'!$GU5>0,ROWS($1:1),"") This compresses a list down to only those that have a non-zero...
  4. J

    Vlookup with 2 conditions

    Beginning in Column H3, based on the value in column G3, I want to return the starting goalie for the game. So for game 1 I want to return "Pekka Rinne", Game 2 "Jusse Saros" from the array $A$3:$D$12 The linked picture of the example sheet, the eventual array will be 2000 rows...
  5. Q

    Table Lookup

    I'm trying to create a look-up formula that fills in cell values in accordance with corresponding variables from different tabs. For example: In the tab "Match-Up", cell "J3", I'd like the formula to display the number of games "Auburn" has played (according to the data found in tab "Auburn")...
  6. R

    Grabbing Last Value of Column, but...

    As the title says there is more. I have some data (soccer scores). What I want to do is pull the date of the last game PLAYED by each team. I used to have a formula but I can not find it to the best of me. <colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody>...
  7. R

    Help with totaling up currency for a game

    I'm trying to make a spreadsheet as a shopping list within a game I'm playing in my spare time but for the life of me, I'm not able to figure out how to add up the values such that it correctly matches the game's values. 100 copper = 1 silver 100 silver = 1 gold An example can be found below...
  8. S

    football table

    https://1drv.ms/x/s!Aq3WqOz73fYygYUinBF1m9sbdkyMaw?e=c78rMA I have created the above file, but I am trying to modify it, so I can record goal scorers, for each game. I want to see how to make it better, any ideas please. Regards Stephen
  9. A

    Any Excel VBA or Excel functions that can help with general lottery forecasting?

    Permission to post, admins... Mostly the posts here about the lottery concern with random number generation, with pick-3 games and with lotteries dealing with huge numbers (e.g. 5 out of 90). I am only concerned with general, simple lottery forecasting concerns. So, I'm wondering if anyone...
  10. L

    NOOb Question. Excel game not working in 365

    Hello We have a very popular game we play at our workplace called bubble shooter. However after the company has updated to windows 10 and excel 365 the game no longer works. When I run the compatibility checker it says "Uninitiated activex controls can not be transferred to the selected file...
  11. 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...
  12. P

    Dropdown list not matching conditional formating on list, need a solution.

    Hey All, I'm trying to track what games friends have vs what games I have, etc, so I decided to use Excel and make a list, etc. Then when the weekend comes I can just look who is around and decide on a game we are playing. When I do a drop down list to allocate the game names to the person...
  13. L

    Getting results with multiple criteria and multiple results

    Hello all, I have a worksheet that has all my board games and relevant playing data. Column A is the minimum players Column B is the Maximum players Column C is the Game Type (Board, Dice, Etc.) Column D is the Play Type (Co-Op or Comp) Column E is the Game’s Title I was to have a section...
  14. T

    auto insert row

    <tbody> A B C D E 1 Player Game 1 Game 2 Game 3 Game 4 2 3 Total Total Total Total 4 </tbody> Morning people Is there anyway I can get Excel to automatically enter a new row once I've populated A2:E2? The behaviour I'm looking for is for the current row 3 to...
  15. J

    Tracking player participation throughout season

    I've got a roster report with game number in first column (A) and player name in 4th column (D). Would like to represent the season in another way. Want the list of players on the team in one column and the game # in the top row. With the corresponding cells either having an X in them or...
  16. E

    Sort by Column

    Hi, I copy from a website and paste in excel like this: https://yadi.sk/i/B8kbXytFc6b19w I don't know if it is possible or not. What I want is that I Sort the list by column C (time) but because each game is in 2 rows then I cannot do it because I am having a mess like this...
  17. S

    locking drop down menus after a certain date and time

    I'm running an NFL knockout pool with 750+ people and have a sheet prepared where each player has a drop down menu to choose a team every week to win and it is already validated to where they can only choose a team one time all year. I need to lock certain cells after a certain time and date...
  18. S

    Look up values in a row and pull corresponding datat to a cell in the same row

    The attached is a game schedule for a pool league. I'm trying to pull the data from the Game Table to the Team Table to the corresponding matches. Eg. If i want to pull in the opponent From Game 1 on 4/11(7 vs 3) and put the opponent 3 under 7 and also put opponent 7 under 3 <tbody> Date...
  19. J

    Can you delay a calculation until required data is entered?

    When the data is entered in c,d and e in sheet 3 it immediatly updates the average column on the collation sheet. Is there a way to delay the update where the 114.833 value is until the data entry is complete for the three entries? As soon as the 104 is entered it changes the 114.833 to...
  20. G

    How to get the opening odds (bet365, 1.72) of a game that has not yet been opened?

    https://www.betexplorer.com/soccer/scotland/championship/ayr-morton/EXyx7gQB/#1x2 DoEvents bookmakerFound = False Set tRows = HTMLdoc.getElementsByTagName("TR") For Each tRow In tRows If tRow.getElementsByTagName("TABLE").Length = 0 Then...

Some videos you may like

This Week's Hot Topics

Top