teams

I have a table of football teams one column wide and of 10 rows. I want to create a table with teams down the left hand side and along the top so effectively creating a grid of all teams playing against each other 100 cells (I know you have to blank some) I'm using tables because teams might...

Sorry if title is a bit misleading. I am trying to find a way to search for duplicate data in columns 1 and 2 to see if they are on the same date that is in column 3. To clarify a bit more, I am creating a sports schedule. In columns 1 and 2 are the home and away teams. In column 3 is the date...

Ok first I will apologize cause this is not just an Excel question. I have Excel workbooks linked to each other on a file share. I wan to move them to TEAMS which essentially is SharePoint on the backend. The question is how do I link sheets form one file in TEAM A to a file in TEAM B? I can...

I want put NFL grid schedule into teams worksheets. look at worksheet Teams by division. I want a vba code on the button is on worksheet that is called Put schedule into teams worksheet. GET PICTURES HERE IS ZIP https://1drv.ms/u/s!AnJwxxiz0Ezpg8c5giTqpAFxNZfW7g GET FILE HERE...

Hello All, If there is a technique for enabling macros in Microsoft Teams, please tell me. I developed this shift pass-on macro filled workbook, and now my employer wants to upload it to MS Teams, and of course all of the macros are disabled. I searched the Forum here and am surprised that...

I don't know if excel will work for this so let me know thoughts. Trying to create a macro to create a racing schedule. Criteria : Multiple clubs, each club might have 1 to 6 teams. 2 teams race at a time against each other. Each race might be a 3 of 3, 4 of 4, 5 of 5, or best 3 out of 5...

https://imgur.com/r5isISk hi everyone the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is...

I am trying to do an if statement based on another if statement: So if someone is In a team I want the formula to do another If statement based on this. Below is my current formula: =IF(C2<54%,"1",IF(C2>=80%,"2","3")) But I need to repeat this if statement 3 times as I have 3 teams with...

Hi All, I ran into a wall and hope someone can help. I currently have a clunky spreadsheet that will randomly distribute 16 people into 4 teams of 4 for our volleyball games. What I actually need to do is for the spreadsheet to distribute 20 people into 4 teams of 4, and hold the 4 remaining...

Hi All I am going to try and explain this a best I can. I am trying to create a spreadsheet for my football league. On one sheet I have a table of all the teams in the league and then individual tables for each teams showing the players. On another sheet I want to enter the results from the...

hello im looking for a fixture creator for playing on the season 4 to 5 time each teams and we are playing against 2 teams each tuesday the number of team can also change from 12 to 14 can anyone help me ? Regards

I need download data from sport webpaes which runs upto 150 matches or so, depending on no of teams participate in the tournament and each match will have two pages. for eg: to download data for match between baroda vs mumbai , gujarat vs maharashtra, mp vs...

Hey all, I am trying to set up "draft boards" for a youth sports organization and we run the drafts in standard snake order (see example below). I have to do this multiple times per year for for varying number of teams (sometimes as few as 8, sometimes as many as 22) and it gets tedious...

as suggested by Sandy666 I a man starting a new thread. I have a list of 160 golfers made up of 80 couples. These couples have different handicaps but to make it fair I am trying to make up 40 teams of 4 people keeping spouses together and trying to get the total handicap for each 4 some to be...

Picture of spreadsheet: https://prnt.sc/ly46pc Hi all, I Would like to be able to filter the data shown based on a dropdown in D5. The 3 options are the teams: Estate Planner, Advisor Team, Review Team (employee names have been blanked out for the image) When a team is selected in D5 I would...

Please allow me to apologize in advance for my lack of knowledge and I would greatly appreciate your help. To be brief, I have a workbook which contains a few worksheets. One of which is a list of NFL teams (Team List) in column A. Each team has additional columns with data in columns B-F...

Hello, I have a workbook with multiple sheets, as a template. The individual sheets get sent out to teams to fill out and return. Once returned, trying to find a way to then combine their individual sheets back into the main template workbook with their original sheets without having to copy...

Hello experts, I am trying to create a volleyball league schedule on excel where I can place scores(I14:I17, K14:K17, Q14:Q17, S14:S17) that automatically calculate and update the cells that show the standings (E2:E9, F2:F9). A B C D E F...

I am looking for an automated solution to update One excel workbook on a weekly basis from 31 Microsoft Teams weekly workbooks. Each team has four members, a captain and three members. Each week a new workbook is created with 5 worksheets. The first worksheet is for Team Points. It gets...

Hi I’m hoping you guys can help me, I’ll try to explain what I’m trying to achieve and hopefully it will make sense. The data is for sales figures, the worksheet it set up asfollows Team 1: Headers - Consultant Name(D3), Client(E3), Percentage(F3), Margin (G3), Weeks (H3), Value (I3)...