Taking Team Names Into Two Cells?
May 21, 2014How i can take just team names in A column as home and away to B-C columns ?
View 4 Replies
ADVERTISEMENT
Positive Cells Taking A Zero Value
Nov 4, 2008I have a code below to only allow a number to be entered into one of 2 cells. I'm trying to do conditional formatting based on these to cells, and the evidence is showing that even when I type a value into either I21 or I22, they are taking on a value of zero.
I have conditional formatting stating that if I21>0, then do one thing. And in a separate cell, I have =I22>0, then do another thing. Neither works, and even using =I22<>0, then do formatting, and it doesn't work, telling me that the assumed value is always zero.
Taking Percentage Of The Larger Of Two Cells
Sep 19, 2006I hope my title was clear enough, but I’m not sure how to set this up. I have numbers in cells B4 and B13. I want to take the largest of these two numbers and multiply it by 0.85. I then want to take this number and compare it to a number in cell B23. If B23 is greater than the larger of B4 and B13 X 0.85, I want B33 to display “No” in a boldfaced red font. If B23 is less than the larger of B4 and B13 X 0.85, I want B33 to display “Yes” in a normal black font. This formula will be in cell B33.
View 5 Replies View RelatedTaking Text From 2 Cells And Inserting Into 1 Cell?
Aug 16, 2013Is it possible to take text from 2 different cell and inserting into one cell?
For example:
Cell A1 reads 'John' and cell A2 reads 'Smith' can I make cell A3 read 'John Smith' by taking those two bits of information?
Taking The Value Of A Range Of Cells From One Workbook And Place Them In Another
May 12, 2007I've been trying to learn how to write code in VBA. I've been learning for about 2 weeks now (trying to learn it for work) and heres my problem. I have a macro that will create a pivot table from raw data that I input. From this pivot table, I want to go to the last row in the pivot table (the row that takes grand totals of each column of data). I want to write a macro that will take those values (located in a workbook called AR age sorting) and place them in cells in another workbook (called AR aging analysis). Basically cells D6-D9 in workbook "AR aging analysis" should equal the values of the last row in my pivot table in workbook "AR age sorting" (last cell with data in columns J-M). I thought this would be easy but I've run into some issues. Heres the code I use:
Sub aging_summary()
Dim Sheet1 As Worksheet
Dim Sheet2 As Worksheet
Set Sheet1 = Sheets("AR age sorting")
Set Sheet2 = Sheets("AR aging analysis")
For n = 10 To 13
For M = 6 To 9
Sheet2.Range(Cells(M, 4), Cells(M, 4)). _
Value = Sheet1.Range(Cells(n, 1), Cells(n, 1)). _
End(x1Down).Value
Next M
Next n
End Sub
I don't want it to copy and paste the values since I just need the value, not all the extra formatting and what not that is incorporated in the pivot table. When I try to run this I get an error message, saying that there is an application-defined or user-defined error.
Random Team Generator?
Jul 11, 2013I am organizing a sports tournament and would like excel to randomly generate the teams for it.
We have 20 people who will be organized into 10 teams of two. how to setup the formula to have two people randomly paired together without duplication. The names will be further used in other formulas for points calculations.
So, I have the names as A1:A20 and then would like the teams generated from B1:B10 and C1:C10 with the team being the row and the team members in the B and C columns.
Team Selection By Web Query
Mar 2, 2009i have an idea that i will be able to select a team in sheet1 cell a1 via a dropdownlist and also c1 giving a home and away team
all teams have there own unique number which i would be able to list them all
it would then look at c1 compare it against the list and use that number
then on sheet two
it would return the results
web address is [url]
arsenals number is 142
aston villa are 154
Sports Team W/L Counter.
Jan 8, 2010i want columns T,U,V,W to continuously count wins and lost for the teams..if i
change the teams names i want T,U,V,W to read "0".
Any team can play any one.
also this is kinda a part 2 (really small part)
I'm trying to use Today function but cant get it to count every other day..
so for example tomorrow will also read "January 7th 2010"
Sheet14
MNOPQRSTUVWXY2
3
4
Team 1VSTeam 2W/L Count
5
LostWinTeam 1Team 2
6
WinLostWinLostWinLost
7 .......................
Keep Tally Of Team Scores
Jan 19, 2008I need to create a sheet probably involving macros where I enter a numerical value into a cell (say B5) I want the sheet to assign a score to the value I enter and then add the score it generates to a table of values. Once ths is done I need it to automatically clear the original value I entered ready for me to enter a new value - rinse repeat..
e.g.
into B5 I enter 15 - on the right in the results table there are headings v w x y and z
say 15 scores one point for w and one point for z I want the sheet to add 0 to the totals under v,x & y and add 1 to the totals under w and z.
Then I want the sheet to clear cell B5 so I can enter a new value without manually deleting the previous entry.
If I can also copy the value I enter into a "history" which simply lists all the values I enter as I go along so much thebetter.
Drop Down Menu That Allows To Pick Any Team
Apr 11, 2009I’m trying to do now is I have a drop down menu that allows me to pick any team that we can face in the season. Once that is chosen what I want to show is the individual stats against that team. Now right now I’m just trying to work out the formula to see if it works.
The formula itself is half working. For some reason some of the selections aren’t showing up like there suppose to do.
Random 12 Team Schedule Generator?
Jun 17, 2013I have 12 teams, 4 divisions of 3... they play each team in there division twice, and every other team once... What's the easiest way to make something to randomize this automatically? This is for a contest at work that starts over every 13 weeks.
Obviously there can't be any duplicates week to week.
WeekABCDEFGHIJKL
1BAAEDDHGGKJJ
2BAAEDDHGGKJJ
3CCBFFEIIHLLK
4CCBFFEIIHLLK
5DDDAAAAAAAAA
6EEEBBBBBBBBB
[code]....
Create Team Fixtures Table
Jun 25, 2008I need to create a full list of fixtures for a football (Soccer) league i am involved in.
i believe this is a multi stage project that i need to tackle in bite size chunks.
I have a list of teams, division that they play in and there home stadium name.
my spreadsheet has 2 sheets visible at the mo...
Rules:
I need to create a list of all games that require to be played.
All teams in the same division must play each other twice, once at the home stadium of each club.
Only division 1 clubs play against other division1 clubs
Only division 2 clubs play against other division2 clubs
I need a full list of matches to be generated in my worksheet called "required Matches"
Random Pairs Of Numbers For Team Match-ups?
Jun 24, 2014I have a spreadsheet with 14, or maybe 16, or maybe 40 names in column B.
A1 = 1 B1 = JOE CITIZEN
A2 = 2 B2 = JANE PERSON
...
A17 = 3 B17 = JACK DOE
and so on...
I want to randomly assign these names to pairs using a macro button, and basing it on the number of players (C1)
So if C1 is 12, I'd like the function behind the macro button to come up with 6 * 2 numbers (2 and 11, or 4 and 7,
all completely random, but within the 12 specified in C1) and write these random values in Range D1:E6
(if C1 is 18, then the range to write in would expand to D1:E9).
I don't know enough about writing code to be able to pull this off .
Create Separate Sheets For Each Team By Year
Feb 27, 2014I have a code that will create separate sheets from “SDL_Calendar” sheet for each team and its working fine. Modify the code to create sheets for each Team BY YEAR based on user selection in Cells “H6”, “H7” and “H8” in “P6_Report” sheet. For filtering BY YEAR Column "D" Can be Used in “SDL_Calendar” sheet.
I have attached the work book of what I am trying to accomplish :
[Code] ......
CreateSheetsByYear_new.xlsm‎
Formula For 2 Low Net & 1 Low Gross Score In A 5 Man Golf Team
May 25, 2008I am using Excel 2002 in Xp and also want to use the spreadsheet on my Pocket PC using Pocket Excel.
I have a column of 10 numbers with rows 1,3,5,7 & 9 representing the individual gross scores of the 5 team members. Rows 2,4,6,8 & 10 have either a 0 or -1 (calculated) in them representing the strokes (or discount) the player receives for that hole. So the net scores for each player will be row 1 + row 2 and so on.
I need a formula that will calculate the total of the 2 lowest net scores and 1 low gross score with the score for each player only being used once which will then represent the team score for that hole.
A sample column would have 4,0,3,0,4,0,3,0,5,-1 in it.
Random Team Making From Database Of Player And Ratings
Dec 8, 2013My friend and I have created a Wallyball league (volleyball played on a squash court). Every week we have more and more players and making the teams is more and more complicated and time consuming. I created this Excel file to try and generate random teams faster.
team selection.xlsx
The file consist of :Jersey no. and player (A and B)rating if playing (C)rating (D)playing on a given day 0 or 1 (E)wallyball courts to generate random teams with a team rating and differential rating.
The only thing it needs is a non-repeating function (as of now, one player can be selected many times)
Also, the players should not be selected if they are not playing on a given day (column E = 0)
I have to do this WITHOUT using macro (1. I'm not familiar with macros ; 2. I have a free starter version of Excel, I don't think macros are enabled).
Rotate Squad For Darts Team Excel Generator
Apr 8, 2014Problem: Have a squad of 8 players in my darts side. We have 12 games in our season and each game requires 4 players so each player will play 6 games. 6 of these games are at home and 6 are away.
I want to create an excel sheet whereby a team will be picked for each match. Each player will play at Home and Away 3 times each. And the same group of players will not play with the other players each time.
eg. Week 1- Team Players, 1, 2, 3, 4
Week 2 - Team Players 5,6,7,8
Week 3 - 1,3,5,7
Week 4 - 2, 4, 6, 8 etc.
Where to start. There are multiple variables.
Display One Instance Of Each Team Name As The Page Header Upon Printing?
Jun 12, 2013I'm working on a simple spreadsheet with individuals divided among teams. Each team is separated by a page break, so the column displaying Team Name repeats the same team name all down a page, and then another team name all down the next page, and so on. I've been searching for a way to display one instance of each Team Name as the Page Header (or just at the top of each page) upon printing. I've included an attachment for reference.
View 3 Replies View RelatedUsing Solver To Calculate The Optimal Fantasy Football Team?
Aug 30, 2013Is it possible to calculate the current optimal fantasy football team from the attached data and constraints listed on the 'solver' tab?
View 2 Replies View RelatedRandom Team Generator For Hockey With Two Sets Of Data?
Apr 24, 2014I am trying to build an excel spreadsheet for a hockey program I'm coaching that will do the following:
Create 4 teamsThere will be a Team 1 White/Dark, and Team 2 White/DarkUse 2 lists to distribute players evenlyThere are a disproportionate amount of players on each list. There are 8 Majors, 12 Minors. 2 Majors maximum need to be on every team.Every week, the roster will be different (some don't show). I need to be able to hit 'randomize' and exclude certain people, and still have the lines 'relatively' similar This is an essence two 3 vs 3 games, with a white vs. dark on each side of the ice (2 half-ice games). If there are 3 majors on each side (6 in attendance), one side will have a white with 2 majors, the other side will have a dark with 2 majors.
I'd also like a way to keep track of who's played with/against who, so if I can export that data set to ensure I don't get a duplicate team...or a primarily duplicate team.
To Collect Data From A Darts Team And These Values Reflect
Jul 4, 2006I am trying to collect data from a darts team and these values reflect
the number of points won in a team game (ranging from 0 - 3). This will
probably be simple for the experts here, so I'll let fly:
I have a table with six names across the top. In the rows below there
will always be two cells that have number values ranging from 0 - 3
while the rest will be blank. Those two numbers however, will always be
the same. I am trying to write a formula that will determine which
columns have values and return a single letter value (first initial)
for each name. Since all the names are different that is not an issue...
Copy To Specific Team Workbook Dependent On Manager Name
Apr 29, 2012I've been working on a userform that I've been adapting from a workbook I had set up to record real time stats. Its pretty much where i want it to be now and I am trying to focus on using the stats created by the individual users to populate team stats. There will be many users using this and many different teams. so i imagine, it wouldn't take too long for just one workbook to fill up and cause problems. Would i be correct in thinking that an IF statement in my current code (that's set up to send to one master sheet at the moment) that will pick out the manager/users name from the userform and send the data to the respective teams workbook, would solve this problem. Or am i over thinking this and is there a more simple option.
Code:
Private Sub UpDate_Raw_Click()
Dim SourceRange As Range
Dim DestRange As Range
Dim DestWB As Workbook
Dim DestSh As Worksheet
Dim Lr As Long
[Code] .......
Perform A Count On Match If A Team Has Won, Drawn Or Lost
Jul 9, 2008I have the following data in a number of cells and I would like to perform a count on match if a team has won, drawn or lost
Nottinghamshire beat Derbyshire by by 53 runs
Lancashire beat Yorkshire by 30 runs
Durham beat Leicestershire by 8 wickets
Midlands/West/Wales
Worcestershire v Warwickshire - No result (Match abandoned)
Gloucestershire beat Somerset by 8 wickets
Send Mail Through Outlook To Team Members For Their Pending Trainings?
Jan 5, 2014I am using an excel where I want to send mail to my team members for their trainings pendings,
Few trainings are once in a year and few traings are monthly.
Compare The Pts Values And Then List The Team Standings Based On Those Points
Sep 17, 2009I have a list of nine teams from B13:B21 with Wins in column C, Losses in Column D, Ties in Column E. Pts are in Column F (all of these run row 13 down to 21). The team listed in B13 has a cell name of One in the Name Box, team in B14 has a cell name of Two, etc up to Nine.
The pts total for each team is also named, so F13 is called ptsone and has a current value of 8. F14 is called ptstwo and has a value of 10, etc.
I'm trying to do is in a different area of the spreadsheet put a formula that will compare the pts values and then list the team standings based on those points.
Calculate Individual Contribution On Customer Satisfaction For Entire Team
Oct 23, 2012I am planning to calculate the individual contribution on customer satisfaction % for the entire team.
Currently the layout looks roughly like this:
C2 - contains overall team Csat %
C4 - contains total number of surveys received
C9 -> C15 contains operator names
D9 -> D15 contains operator individual csat %
E9 -> E15 contains operatore number of csats received
Using the data above I thought I should be able to generate a number or % that would indicate the individual's contribution to the overall score.
Excel 2007 :: Select Team Leaders Name And All Agents Reporting
May 17, 2013I am looking for a formula or VBA code that will allow me to Select a Team leaders name and all the agents reporting to that team leaders would populate. I have the first part of that problem solved but its getting the agents names to generate uniquely that I find problematic.
Below is a step by step example of how i intend it to work
Step 1
I select the Teamleaders name
Shelaine
Once that has populated the Team Names automatically appear
Shelaine
Score
Andrew
20%
John
30%
Mark
40%
Sarah
50%
June
60%
The scores will populate on its own as I will include a Vlookup formula to generate the scores, Its just the Agents names. I am using Excel 2007
Obtaining Largest Number In A Range But Then Pulling Back Name Of Team
Oct 16, 2013I have a set of data like below, I am trying to get a formula to look at a range i.e. May column and then select the highest number in that range but rather than returning the number returning the team name, is that possible? Not sure where to start...
Jan
Feb
Mar
Apr
May
Jun
Team 1
25087
23029
32991
21319
25271
25136.8
[Code] .........
Counting And Lookups (count The Number Of Team Members Listed Under That Supervisor)
Feb 22, 2010I have roster that has 12 teams on it, each team has their own column with the supervisors name in the first row. I want to look up the supervisor and count the number of team members listed under that supervisor.
View 4 Replies View RelatedFind Out How Many Games Played By The Selected Team Had The First Goal Scored After A Certain Time
Mar 7, 2009I currently have two columns one for each of the following formulas and then another column that's works on the result of the two together but what I want to know is how do I get the two combined?
=COUNTIFS('08-09 Scores'!$C:$C,$B6,'08-09 Scores'!$CB:$CB,">="&$AY$5,'08-09 Scores'!$CB:$CB,"<="&$AZ$5,'08-09 Scores'!$AT:$AT,">"&$BA$5)
=COUNTIFS('08-09 Scores'!$C:$C,$B6,'08-09 Scores'!$CB:$CB,">="&$AY$5,'08-09 Scores'!$CB:$CB,"<="&$AZ$5,'08-09 Scores'!$W:$W,"="&$F$5)
I've put the bits that I want to be "or" in red, The first bits are obviously the same and just the last bit needs to be or.
I am basically trying to find out how many games played by the selected team had the first goal scored after a certain time(the first formula)
or the first goal was scored by the away team(the second formula)