# team

1. ### Analysis of trend between successful cases vs frequency (scatterplot)

Hi! I'm not sure how to go about solving this - but I need to do an analysis using excel charts to assess if there is a trend between the performance of a list of managers handling their team of staff who are ranked either successful / unsuccessful vs the frequency of their attempts. So my...
2. ### SUM by Month with IF Statement

I need a formula for E2 and F2 In E2, I need the sum of the amounts of February. Also, if Column B says "TEAM" then divide the amount by 2. So E2 total should be 450 because 200+200+(100/2) In F2, I need the sum of the amounts of March. Also, if Column B says "TEAM" then divide the amount by...
3. ### Slicer setting for 'Contains' rather than equals?

Hi all, I am wondering if/how i can modify either my slicer settings or my data in order to achieve a regular looking slicer that acts more like a filter for 'contains' rather than equals... So i have a table with a list of my teams and another table with a list of tasks and which teams are...
4. ### Multiple MsgBox based on various cell values

I am just picking up the MsgBox macro in VBA and have come to a snag. I'm working on a file for our company trainer to jazz up their training class with an Excel game. Within the game, I am counting the number of times a 1 appears within a certain group of cells. Those 1's are hidden and...
5. ### Looking to do a sports league total rank sorted/based on - 1.seed, 2. team name, 3. total points

Hello I created a Microsoft excel sheet for a sports league I play in. There are 3 divisions the league, each win being worth more points the higher up. Every 3 weeks, the top 4 teams on the top of each division (except the top division) will move up, while the bottom 4 will move down (except...
6. ### Reference Lookup need for a Name and Date set

I am trying to look at a user log data set and assign a team based on the user name and the date. I have a seperate table with user names and the dates they were on the different teams. VLOOKUP will find the first entry for the user but I can't figure out how to have it also look at the date...
7. ### Form/Subform Help

Good Afternoon All i have a form which contains a sub-form The form has one field in called Team and the sub-form has various fields of which one is called team The database is used to collect weekly results and to create League tables and reports and create web-pages for uploading to the...
8. ### Trim cell that has carriage return and split

Hi, Had a macro that worked, they have now changed the data. I have a column that can contain a name with the following after the name , space, then (Team Member) ie George Smith (Team Member) The next cell may have up to 6 names, each with (Team Member); after each name Gary Wing (Team...
9. ### How to make entire row connected together ?

Hello guys, So I have an Excel file containing two sheets: - `Teams` (which contains details of teams and time schedule of their matches) - `Results` (contains calculation and number of matches and results, etc). What`Results`does is that each game that has launched status on `Teams` it...
10. ### Need Formula data based on Multiple text/value conditions

Hi Team, Can anyone help me with below requirement....here is the data <tbody> Customer Product Name Amount Contribution by Final Status Cust1 Product 1 17,991 Team 1 Cust2 Product 2 19,901 Team 2 Cust3 Product 3 18,948 Team 3 Cust3 Product 3 10,730 Team 1 Cust5 Product 5...
11. ### pull data from separate tabs to "dashboard" tab, removing duplicates and counting % of cells poplualted, etc

I have a spreadsheet with six tabs (one for each team member) and one additional tab to be used as a dashboard. I'm trying to pull data from each tab and have it populate the dashboard tab. Each team member has the same layout on their tab and uses the same status names. So, Column E has a...
12. ### Q: How do i keep a row connected together(moving together) while shifting/adding row above it?

I have an Excel file containing two sheets: - `Teams` (which contains details of teams and time schedule of their matches) - `Results` (contains calculation and number of matches and results, etc). What`Results`did is that each game that has launched status on `Teams` it gets on...
13. ### greater than function (Index,Match....)

hi just trying to find a Name based of the score this is just an example on my excel sheet its has got much more teams and names so it will take a long time to use IF function Team 1 Jack, Dave, Mark and Tony Team 2 Kev, Ste, Mike and Bob if I want to give 40 to team 1 it should come up...
14. ### Filling a two dimentional Table based on the columns of other table

Hello, I have a scheduling task, I am schedueling people in a table, after that I wanted to seperate each team working in each aircraft to be shown in a different table. So I have a two condition, Team and A/C. I tryed to use Index + Small function, but joining the conditions with AND will...
15. ### Average Revenue per month

I need assistance putting together a formula in a separate column that will give me the total average retainer for each client based upon the number of months below. Since there are duplicate months i cannot simply do an average. Tried doing an average if formula but need to embed something...
16. ### SUMIFS Using Dropdown Lists

Hello,<o:p></o:p> I have set up a successful SUMIFS using two criteria toprovide a total figure depending on the criteria selected from the drop-downlist for both criteria (=SUMIFS(B2:B40,A2:A40,F40,C2:C40,G40). <o:p></o:p> Range B2:B40 contains number values<o:p></o:p> Range A2:A40 contains any...
17. ### Multiple Worksheet_Change macros in one worksheet

Hi Excel gurus My 2016 workbook requires the following Macros and also a suggestion on Data collation I could not upload a file as the forum rule says but tried to copy the table but it is not copying the borders. Please let me know if it is not helpful 1) MACRO in the ‘Task Allocation’ sheet...
18. ### Conditional formatting ore?

Hi there, Greetings from Denmark :) I need help to complete this case/file, I do for my local sports club. So here is what I need. When a new player has to be entered into the sheet. A team is assigned by selecting a team from the drop list in "select team" Column.. So fare so good...