teams

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

Hi, I am trying to find the win and loss streaks for set of games to find out whether both teams have scored in match and if so carry it on as a streak. Thank you

I have a simple scheduling table to determine 16-game schedules in a league of 32 teams: https://i.imgur.com/ShtN22o.png The teams are numbered 1-32. The games in the red triangle are all the unique games (everything repeats on the other half). A team's schedule can be read across or down...

I am using Excel 365, and for the life of me I cannot get to produce a Pivot table from two ranges. Each range has three columns, with the same headings and the same data formats. I am calling up the PivotTable wizard, selecting the Multiple consolidation ranges, but when the pivot table is...

Hi all, Hope you are well and thank you in advance for taking your time to read my post. Not sure if it is at all possible, i have a pivot table with slicers and would like to restrict the information end users can view based on a password I provide them. e.g. the pivot table will contain...

30 people (Person 1, Person 2, ..., Person 30) 3 roles (Role A, Role B, Role C) 12 months I need to create 10 teams of 3 people to perform the 3 unique roles. The teams and roles will rotate per month for a year. Conditions: These teams will need to rotate randomly every month where...

This is a bit of a rush order, since it's for an NCAA pool due tomorrow. i have sorted my teams by odds of winning, but different seeds cost me differently. So I have 3 columns: team-odds-cost and I would like Excel to tell me: "If cost can't go over 100, these are the N teams to choose to...

Hi, So I am wanting to help make some of our team's work a little easier but have no idea how to go about it. We have this spreadsheet that is filled in with information needed by various teams to create accounts. These teams fill in the information manually from a ticket that gets...

I have a list of names from the 5 teams in my division in alphabetical order. I would like to have a macro that pulls just my teams names and info from the list and places it onto a separate sheet for easy reading. How would i set this up? Thanks

I'm a phys ed teacher and recently I posted up a workout log on Microsoft Teams for my students to download, fill out and return to me electronically. Since Teams is still kind of glitchy and not all students know how to access it as easily as a google spreadsheet, I was trying to come up with a...

I've recently discovered that Microsoft's in-browser Excel editor for SharePoint and Teams does not allow users to edit text boxes. 1) are there any work-arounds for this? Also how has microsoft not fixed this? I've found documentation from this going back to 2010.

Create multiple searchable drown. I only got one searchable dropdown list of teams

I am having an event in which contestants can enter the event either as a “Header” or “Heeler”. They may enter the event up to 4 times. Once all of the contestants are entered into the spreadsheet I have created, I need to click a button labeled “Draw” and have it sort the two columns (Headers...

Good evening all, Im having small issue trying to get my head around a league table i have to make... Basically there are 84 teams who need a specific KPI ranked daily for the rest of this month. Basically the bottom 10 drop out daily and can only enter if they are in the top 10 at any point...

I have sports statistical data and both the home and away team are listed on the same line. I am trying to create a way to do a pivot table that would allow me to look at a teams statistics whether they played at home or not. The way the sheet is structured, I can do a heck of a pivot table...

Hi, I'm not entirely sure how to phrase this and can't find the solution through search Basically, I have a number of teams with 3 people per team. Each team member has a score which ads up to a total score, I would like to sort my teams from highest score to lowest without disrupting the teams...

Hello I have a list of teams playing each other with away teams in A1:A13 and home teams in B1:B13. I then have a list of players (column C) with the corresponding teams with their team listed in column D. How can I have excel automatically populate the opposing team name by referencing back to...

Hi, everybody! I would like to request some assistance for the following: each weekend me and a group of friends play a football match, and we always have trouble when making the starting lineups, so I want to create a formula or a macro that can create random, balanced teams based on the...

I'm looking for a formula to create a swimming league of 6, 7 or 8 teams (depending on how many enter) where each team has one home gala and plays away an even number of times against the other teams. With an even number of teams there were would and imbalance, say playing some teams twice and...

Hi all, Hope someone can help me, I'm really struggling with a problem that I think should be possible. I have a sports league of eight teams. I would like to organise a fixture list so that three teams are at each fixture on a Sunday morning. This would mean that six teams are involved (two...