player

hi guys, im running a tournament and i have alist of names in excel...and as per our rounds we dont like people playing the same person twice, so matchups are made for round 1, then we get our scores in and determine who plays who in the next round...generally the top scoring players will play...

Below is a snapshot of my spreadsheet. All numbers (hits) are populated (linked) from other sheets in workbook depicting each specific games. The GREEN background seen is currently being formatted manually. I am now trying to figure out how to CONDITIONALLY FORMAT the cells to show a 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...

I like to play a simulation baseball game where each batter has a card which attempts to replicate the players actual performance and dice are rolled to determine the player bat outcome. The company that sells the game also sells a spreadsheet and claims the player data from the cards is in...

Hi, For the most part I am quite proficient in Excel, but there's something I am trying to achieve but don't exactly know how to and what approach to take. I am making a D&D sheet for a games night I have next week and I wanted to have a hidden page that calculate's whose turn it is based on...

Hi All, I currently have a formula to show if cell I3 shows the mentioned values that it will input Key Player into cell J3, =IF(OR(I3="6-6",I3="6-7",I3="6-8",I3="6-9",I3="7-6",I3="7-7",I3="7-8",I3="7-9",I3="8-6",I3="8-7",I3="8-8",I3="8-9",I3="9-6",I3="9-7",I3="9-8",I3="9-9"),"Key Player","")...

Hi, I need some help on a formula that will return the sheet name if a certain cell within other sheets is occupied, aswell as the same cell within the first sheet. I do struggle to explain myself at times, so I have linked to a picture of my worksheet which has been simplified for ease. I am...

I have a large spreadsheet to track golf statistics by player, by day, participating by month. Each day a player participates they get a $0 or a positive dollar amount depending on their results for the day. Currently I have a =COUNT formula to track the number of days each participates and it...

Hello all, I need help in the following. I have a sheet with players and the results of their game (in same line) I want to automatically add 1 point if the player won the match (in the points column) and add the number of sets the player won or lost some tennis rules about winning or losing ...

Been messing around with codes and just can't figure this out. <tbody> A B C D 1 Player 1 11 22 33 2 Player 2 44 55 66 3 Player 3 77 88 99 </tbody> If Player 1 is not blank; and Player 2 and 3 is blank. I need 11 to be formatted. If Player 1, and 2 is not blank; and player 3 is...

Hi all. I am looking to use a line graph to show momentum changes in a tennis match. I have a column showing momentum change ( +1 whenever player A win's a point and -1 when player B win's the point). I have then used an IF function so show when player A wins the point but show NA () when...

Here is a screenshot (Image 1) of the information I want to pull. There are up to 30 of these tables at any given time. All have different information. I am trying to figure out a way to first find the team, then find the player on that team and then return the pos (PG,SG,SF,PF,C) to another...

<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 all, Apologies in advance for the excessive post, but hope it makes sense. I am in the process of analysing a tennis match. I would like to look at how many times a player wins just 1 point at a time, 2 points in a row, 3 in a row 4 in a row and 5+ points in a row. From my raw data is have...

Hi all, I am having a bit of an issue while trying to analyse data I have generated from using Dartfish (sports analysis) software. Firstly, I am analysing a tennis match and with the software there is a score panel tool which allows me to track games, sets, and tiebreak scores. When exported...

Hi There, I know this has come up a billion times, but everything I have found has not solved my problem. I have a list of 50 hockey player names, a list of 10 intros, and a list of 10 ending sentences. For example: A1:A50 = player names, A60:A70 intro to a sentence ("I heard that" or "Someone...

Hi, I've created a table below: <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> GOALKEEPER COMPLETE WING BACK (RIGHT) CENTRAL DEFENDER COMPLETE WING BACK (LEFT) ANCHOR MAN ADVANCED PLAYMAKER ROAMING PLAYMAKER...

Hi All, I am wondering if you could help me? I have a table (TBLSJ) which is looking at athlete Jumps a bit like this: <colgroup><col><col><col><col><col></colgroup><tbody> Name Date Jump Type Male/Female Player 1 11/03/2018 47 SJ M Player 2 01/04/2018 54 R M Player 1 03/04/2018 57...

Hi Everyone I really need your help. I have a Table called TBLSJ : <colgroup><col><col><col><col></colgroup><tbody> Date Name Jump height Type of jump 01/02/2018 Player 1 54 SJ 01/02/2018 Player 1 60 Left 01/02/2018 Player 1 53 Right 05/07/2018 Player 1 46 Left 05/07/2018 Player 1...

Hi everyone I need some help. I have a table (called TBLSJ) of data which looks like this: <colgroup><col><col><col><col></colgroup><tbody> Date Name Jump height Type of jump 01/02/2018 Player 1 49 SJ 01/02/2018 Player 1 48 Left 01/02/2018 Player 1 65 Right 05/07/2018 Player 1 59...