team

Hello there, I am looking for a formula that can handle returning an index value based on header names instead of index number. This is because the data source is dynamic. The location of the index value I am looking for will vary depending on the source. There are two reliable constants...

<tbody> DISCIPLINE 1 25-Mar 26-Mar 27-Mar Team 1 205 197 195 Team 2 10 23 15 Team 3 267 290 293 Team 4 56 57 55 Team 5 2 0 4 </tbody> Need code that will allow me to copy/paste daily total (extracted data) for each team into another Excel workbook with a...

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

Hi Team, Query is regarding - Email notification go if change in Combo1 I have already code on "Update" button. If there are any change it simply updates the fields from form controls into access db. Here i have new requirement like, Combo1 contains Team names. If, combo1 value gets...

Hi I have an annual leave planner with six teams. Originally named T1, T2, T3, T4, T5 and T6. The formula below works to calculate the number of people on leave in team 1 if i filter to just team 1. =COUNTIFS(E6:E30,"T1",F6:F30,"X") this formula is written in cell F33 In cell f34 i...

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

Right. I started Power BI this morning for the very first time. I've had no training (the power BI guy here is always too busy). I've very familiar with Excel and Access, have worked as a SQL Server developer so I know what I want to do, just not how. So, baby steps for my first table. I've...

Hello All, I have a workbook, which is placed in a shared drive, as i now need to update the work allocation & for each team member in different sheets under there name. Help required; 1. Need to protect the columns in all the sheets of the team member & allow few columns AB to AZ to allow...

I help run a small pool league. We have about 30 teams. I would like to generate a spreadsheet to assist with team scheduling. We are given a schedule from teh league with teams $'s that tell us for teh session who plays who on what week. But we need to figure out the game tables for them...

I'm trying to create a spreadsheet to control account reconciliations in my team. We have a list of suppliers that the team work through and they highlight the suppliers accounts when reconciled. I'd like to add today's date to another cell when the supplier name cell is highlighted, so that I...

Hello. I have on the 1st sheet the entire results of the Premier league 2018-2019 fixtures. They are set up as a table, from column A to D. Column A = Home team Column B = Home team score Column C = Away team score Column D = Away team This table has the purpose to be dynamic, as i...

hello, the company i work for maintains an employee list in an SQL database that i have imported into excel as a table. i have i used the rank function so that each employee can be referenced alphabetically by team. i have also created a drop down that lists the team name, and another drop...

I have the following sub which copies and pastes a range of data which has been input by user on one sheet (Input) and appends it on (All Scores), which is a master sheet of a thousand or so players and a weekly score over a forty week season. The probelm is with zeros. I have set the workbook...

I'm working on creating a golf scorecard that can keep track of multiple side games. I'm having trouble with one called Vegas or Casino. In said game, two man teams compete against each other by combining their scores into one number. For example: Player A = 4 Player B = 5 Team 1 score of 45...

Hi, I need some help to put the following data into an excel pivot so that I can look at any Oracle Role and see only those responsibilities that apply (ie where the X exists - I don't want to see any of blank cells_). Is there a way of doing this? A regular pivot does not seem to...

The attached is a game schedule for a pool league. I'm trying to pull the data from the Game Table to the Team Table to the corresponding matches. Eg. If i want to pull in the opponent From Game 1 on 4/11(7 vs 3) and put the opponent 3 under 7 and also put opponent 7 under 3 <tbody> Date...

I am trying to sum the total number of player scores (usually 10 players) for a particular team (1 of 60) in a particular week (1-26). This formula will be copied down about 200 rows for both Home and Away Team, across 4 divisions. I'm close, but not close enough! =SUMIF('All...

Hello All, I am having trouble with passwords hoping its a simple fix. I have four sales teams of 5 people who each have their own commission sheet which are password protected to open. The team leads sheet has links to cells in each of his team. So when the team lead opens their file it is...

Hello Looking for help to write a formula that will give me the result of column "C" below. Tried this in my excel and obviously not working.... =IF(AND(COUNTIF((AH287="*team*", AJ287=1), "Yes", ""), (AH287="*team*"), AJ287=""), "Pending", "")) I want it to return Yes if Team and a date, if...

Hi all, please help: I work in a hospital. Front office team answers the phone and books doctor appointments for customers. Our system registers the time and date of the appointment and who booked it. I want to count how many appointments were booked by each team member, per time frame. On the...