player

I have a table of sports teams of which part of it has Captain, Player 1, Player 2, Player 3 etc. and currently has salutation (female only), first name, surname, I have duplicated this part of the sheet onto another sheet where I wish to have the names reversed i.e. surname first, and then...

I have on a Userform 20 Combobox to chose 20 Differens players from cell H62 to H82 My first Combobox 1 works fine but they cant get the Rest to work…. and how did i get the combobox to put the player in cell eksampel Use combobox 1 to set player 1 in cell "B1" on Sheet"Lodtrækning" and...

I'm no expert on Excel. Most of what I do is from watching youtube videos. Right now, I'm working on a baseball lineup program for a sim game that I play. At this point, I have created "lists" of teams. With a macro, I install the team. Keep in mind that there are 9 cells available for...

I want to keep a running total of Points, Events, and Cashes from 40 events. The players will vary from each event. And the list of players in the "Total Table" will grow. Also the Player "Rank" will be resorted after every event. I'm still a beginner, and learning as I go. What am I missing...

Hello, I am very new to VBA, and trying to figure out how to pull stats on NFL players so that I can run analysis on these numbers. I first need to figure out how to create a URL for each player, and I know that there is a way to do this for the list of player names that I have in a column...

Hi, I'm using a dataset of football player scores to try find the highest scoring combinations of players at varying maximum values. Each player has an assigned ID, position, value and score. I have only been able to return the 1st, 2nd, 3rd etc. highest scores per position so far. Ultimately...

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

This may very well be just too big, but here goes ... I've been handed a DARTS SCORE Sheet for a full LEAGUE The owners want to record each time all players score over 99 (>=100) The problem is multipartite: There are 6 players on the Team Each player can play in up to 3 "games" (TEAMS...

Hi all, I am working on a sports spreadsheet for a league. It records daily games between players, and then I've got all time results per player, all time results per match up, and some league records, etc, automated via formulas. I'm looking to add a player ranking to it, but I want 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...

Hi, I am trying to use the INDEX MATCH function to populate Columns E & F in the example below however I'm not having any luck, can anyone advise how to populate multiple values where the results are the same? Thanks for any feedback / assistance <tbody> Person Pos Pos Name 1 Name 2 Player...

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

I have a list of player names that are divided into 5 Flights (A to E). Each Flight is determined by dividing the list of names with associated scores into 20% or less of the total players. Each player has a previously calculated handicap. I need to find the largest handicap value within each...

I have a list of 100 names with associated golf scores/handicaps. I need to develop 5 Flights (A, B, C, D, E) into which players will be placed based on their score/handicap, e.g., players who score par to 10 over par (this is a variable) would be placed into Flight A; Players 11 to ? would be...

Hey all, I am trying to pull a listing of the weekly PGA Tour leaderboard from a website that I will be able to populate and refresh each time I open the document. I tried simply going to Data > From Web > and pasting the URL and clicking ok. The URL that I am trying to use is...

Hi, So I am trying to make a UserForm with 2-way Dropdown. I have a list of players, listed with group, and if part-time or full-time that appears on Sheet 1 like so: <tbody> Player Group FT/PT Player 1 U16 Full Time Player 2 U16 Part Time Player 3 U18 Full Time Player 4...

<tbody> <colgroup><col span="12"></colgroup><tbody> BEFORE Col A Col B Col C Col D Col E Col F Col G Col H Col I Col J Col K Row 9 12.1 33.2 0.3 0.4 14.5 25.6 17.7 0.8 0.9 Row 10 41.1 33.2 33.3 25.4 29.5 38.6 17.7 33.8 0.9 Row 11 Blank Blank Blank Blank Blank...

I know once I see how to do this I am going to kick myself as to how simple it is, but can not figure it out. I am wanting to calculate how many minutes per game each player play in a basketball game. I want the Min/Gm column to sum how many minutes during the game each player played. The...