player

  1. D

    String splitting names with salutations just for females

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

    combobox to cell

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

    Trying to make a baseball lineup

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

    Help Please. How to keep a running total from multible events.

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

    Creating URLs based on on contents of a column

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

    Maximise total team score but limited with team value

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

    Need Help with Index Function

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

    Revenues starting and terminating based on present probability of market entrances

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

    Formula to extract SCORES over 100 from each location of an individual Player (DARTS)

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

    Player Ranking based on Strength of Opponent?

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

    VBA or Formula needed for Leadeboard / Games Round Creator - Help required please

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

    Index Match for multiple values with same results

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

    Changing formula based on player's name

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

    Changing formula based on player's name

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

    Golf Handicaps Values

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

    Golf Handicaps

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

    Automating Excel Table from Web Site

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

    2 Way Depedant Dropdown(UserForm) in Excel

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

    Macro To Sort Data Required

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

    Formula for Basketball Minutes per Game

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top