team

Hey all, I have just taken over as the stats man without knowing to much. The excel file i have been given works great. The problem i have is it only has room for 6 teams but one of our divisions has 9 this season. Would anyone be able to explain how i can add on an extra 3 teams? Thanks...

Hello All, Thanks for having this wonderful forum and I request your help with a small challenge of mine. I am new to excel and not sure if excel can do this at all, but I give it a try. We have a small team of players(around 30) out of which around 20 who come every week to play soccer. The...

We have 3 teams of people which are all filled with different numbers of people. We need to be able to allocate people on a shift equally to each team everyday. And the results be recorded for how many times a person has been on each team over a given period. So we can ensure each person does an...

I am trying to do the following but cannot seem to wrap my head around it. I have a workbook with multiple sheets. For what I am doing I have to pull information from one and compare it to another. It looks something like this: Sheet 1 <tbody> A B C D E F 1 Game # Cards Home ID Home...

I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...

I want to create a macro that Prints 3 sheets from my workbook and then launches the saveAs window The 3 sheets I am looking to print are "Team 1" "Team 2" & "Team 3" Is this possible to do in one macro since there are windows that will pop up for both printing and save as?

I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...

I have an excel document that details the projects we're working on and who the PM is. plus a lot more detail about that project this is one a tab called Team POAP. I want to create a summary overview on a different tab (called Timer Tracker) that shows the PM down column A and then in each...

Hi - looking for help please I have 2 columns which vlookup values within my tab, they are Team Name last month / Team Name this month. I wish to know if these change and report in Column 3. I have about 7 different team names - for this example - North, South, East, West

Hello, I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here. Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales. So every...

I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget...

Hello, I have the results of a survey in an Excel spreadsheet, like this: <tbody> <tbody> Question </tbody> <tbody> Grade </tbody> <tbody> StrVal </tbody> <tbody> Flowers and Decoration Team </tbody> <tbody> -1 </tbody> <tbody> N/A </tbody> <tbody>...

As the title says there is more. I have some data (soccer scores). What I want to do is pull the date of the last game PLAYED by each team. I used to have a formula but I can not find it to the best of me. <colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody>...

Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row. In the example below row 8 would be deleted as AI = 0...

Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Notes, If it is empty delete that Row. In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no...

What I am attempting to is streamline my process of updating my hockey pool each season. It is a keeper league, and so each team can keep up to 4 players from their previous season's team. The other thing is that when a player is kept, his "draft pick value" is one round higher than his previous...

Hi guys, I have a simple Excel sheet which contains data in two sheets (basically a football league schedule) Data is contained in column A (home team) and column B (away team for each match) In column O I manually put the name of the team and formula has to find last four times when...

Hi, Looking for some help on excel chart without using VBA codes (if possible). Team :1 $0.27, Team :2 $0.90, Team :3 $4.63, Team :4 $5.32, Team :5 $0.77, Total $11.88, Above table provide total expenditure forecast for each teams for a future event. The data which will update on daily basis. I...

Hello all, I have the below in a Matrix visual. I'd like to add another column in the visual that would compare the "Score" to the %ile columns to give me the correct value. For example, Team A's score is 0.75. This is more than 0.65 but less than 0.76 so it should be in the 25th %ile. Team B...

Hi All I am finding it hard to get results in the following scenario: I have three worksheets Sheet 1, Sheet 2 and Sheet 3 In Sheet 1 I have a drop-down with values i.e. Team 1, Team 2, Team, Team 3 and Team 4. In Sheet 2 I have 4 Columns with the headings Team 1, Team 2, Team, Team 3, Team...