game

Fairly new to VBA and have an idea that I think is possible but need a ton of help. Any assistance would be appreciated. I am looking to create a Random Dungeon Map Generator in Excel with the intention to make printouts. I think I have the steps down but I have no clue on how to do this and am...

Hello everyone, Today I have come across a very stupid calculation which I just cannot figure out how to solve. I already feel dumb enough as it is so yeah here goes: The table on the right is where I fill in all the "resources" I have (this is for a game, I'm sorry if this isn't meant for any...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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