players

Hello, First let me give you a little background on my problem. This is my first post in this forum. I have tried to find a solution to my problem by searching the web and several forums. However, I have not found one. I have been able to get some segments to work but need some assistance to...

Hi All, I am making an excel dashboard about players performance. I have inserted a slicer (with the names of the players in it), so when I click on it, the different graphs show for this person. But I also want to have the pictures of the players inserted in the dashboard when I click on their...

I have a user form that has 12 Bottons on it 8, 10, 12, 14, 16 ,18, 20, 22, 24, 26, 28, 30. These number represent how many players or teams that are going to play a game. I want to add to each button a workbook that has all the imformation needed. So when I press button 8 the workbook that is...

<tbody> Column A Column B Column C Player 1 vs. Player 2 Player 1 vs. Player 3 Player 1 vs. Player 4 Player 1 vs. Player 5 Player 2 vs. Player 3 etc. </tbody> Hi All, I want to create a fixture table from a list of players (eachplayer in a separate cell in...

Hi Guys, I would be very grateful if anyone can help me with the best formula to use on this one. I help coach with a junior football team and we have a squad of 15 players, but we can only select 10 on a match day, and there are 18 games during the season. Whats the best way to put a...

Hi, I have a list of players & there rating & there all ranked highest to lowest. But, when there are 2 players that have the same rating it only shows the top one, how do i get it to show the next one? Example: <colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt"...

Hi, i'm new to this forum so i hope i've posted this in the right section. What i'm doing is making a spreadsheet for my Football Manager game. I've got everything i need in, i just need to get a formula right to make my "Match Squad" work properly. Each position i've done with all the correct...

Hello, I'm doing a fantasy football draft soon and I'm trying to find a way to automatically have the pick number appear in a cell next to each players name (Pick # column) after I enter their name. Each time I enter a new name the pick number should go up by one. I will be using five different...

Hello ! Actually, I'm facing problem in sumproduct formulae. The file contains three sheets. The sheet “Data” contains the name of the stocks and the respective opening and closing prices. The sheet “Reponses” contains names of the various players of a Mockstock game and the respective...

Back Story: A couple years ago I created a FF Draft Board for my fantasy league. I hook up my laptop to my two smart TVs. One screen shows the draft board. The second screen shows each team's roster as they are drafting. The draft board will fill in the players team and position after their name...

Hi, I'm looking to rank Fantasy Football players. I have the players listed in three columns, one in which order they were drawn in the draft last year, one in which they are expected to be drawn this year and one using their average score from last season. Is there a way for me to average...

Hello. My request is relatively straight forward in excel terms but I am trying to work out how to automatically highlight a cell in a score sheet. For example there are a list of 10 players and each players scores are accumulated. As these scores get higher or in the case of a golf score...

<tbody> Date Player Player Code 4/1/1959 Chris Tom 123 12/5/1962 Dan Boyd 456 5/3/1961 Chris Peter 678 10/4/1960 Tom Boyd 789 </tbody> <tbody> Date Player Code 4/1/1959 Tom ??? 5/3/1961 Chris ??? 10/4/1960 Boyd ??? </tbody> Let's say I have a...

Hi guys. My first post! I am trying to model multiple players entering a market with pre-defined probability. The portion that I cannot solve is starting a cash flow when the players enters the market and ends when the revenue reaches a certain level within a five year period. For example, the...

I will illustrate my challenge by way of a simple example. Suppose I have a list of 25 baseball player names (A1 through A25) on sheet 2. Suppose, further, that I create a "yes-no" drop down in each cell in the range B1:B25 (sheet 2) - this lets me choose which players go in today`s lineup. On...

I have a chart of names, 12 rows by 4 columns. I have named this range PLAYERS. I would like to select a name and have the vba code populate variables with the row number and column number relative to the named range. The range PLAYERS does not start at A1, but rather is in the middle of the...

Hi All, In a situation here! Below is a Competition Leaderboard that I am working on for a client. What he wants is for each round, each Player will compete against another based on their position on the leaderboard. For example in the below snapshot Jack played Kevin in Round 2 because they...

Hello all, I hope you are well. It's been a while since I was here, and Google has been my friend but I'm really struggling with this one. I clearly can't see the wood for the trees because this seems so simple. I have a spreadsheet. In Column A I have my marker column 1 to 5000. In columns B...

I recently created a small database full of NFL players that is split into different positions (linebackers, cornerbacks, quarterbacks, etc.). I also have a spreadsheet in it dedicated to finding a best comparable player at their specific position. In this sheet, there is a list of players at...

I recently created a small database full of NFL players that is split into different positions (linebackers, cornerbacks, quarterbacks, etc.). I also have a spreadsheet in it dedicated to finding a best comparable player at their specific position. In this sheet, there is a list of players at...