team

I have a file with multiple worksheets. Each worksheet has the same format, and each column shares a lot of the same data. Each worksheet is for a project that my team and I work on. What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned...

Hello I have data to analyse game result as follows. Every team has to play twice with the same opponent yielding Score1 and Score2. I have to add total score of each player on a table 2 shown below. The main problem is the number of team will be changing. If a team is added then every team...

L team away L team home L home lose etc. I need to split the text to columns at the L (space). That's an L and a space

I am trying to figure out how to find a missing number in a range of rows. I can get the following to work by hard coding the statements to look at the first range of cells. LowerVal & UpperVal calculated previously (pseudo code below) Dim InputRange As Range Dim ValueFound As Range...

Hello Everyone, i am stuck with one challenge. If anyone can help. I am trying to input the values (name: only one column) in the table using the user form. (Userform contains a text box, 3 radio buttons and a submit button) I have three tables in the same worksheet (example : Team A, Team B ...

Hi, Im still a newbie when i comes to excel. I have a basic understanding of the functions but this one have stumped me I have a spreadsheet that records the date that an action by my team is completed (Column B). They email 2 other departments for a response. When the receive the response...

Hello Everyone , I have created a macro to copy the active worksheet and paste a new one. I want to make a slight modification to it : The newly created worksheet to be pasted on the left side of the workbook rather than on the right (My team is used to this format). Dim sName As String...

Looking for help writing a MACRO to undertake the following. I have a spreadsheet with multiple tabs x 11 - these tabs have team names, for example North, South, West, East. My existing MACRO transfers all of the tabs to a Summary tab at the end. However I have found that when I do this I...

Hi all, any reason why i would be getting a #Value error using the formula: =SUMPRODUCT(--(Season=$LU$2),--(home=$LV5),--(FTHomegoals+FTAwaygoals>MV3)) Season Lu2 is referencing the range of the data i wont to use Home = LV5 is pointing to the particular team & where it would be listed...

I want to distribute points among the riders according to the ranking of the stage. The lay-out: Ranking of the stage in column A:E My rider selection in column G:J Points to display in column L:Q (Here I want to display the results, the points) When a team in column J is present in column D...

Hi there! I'm calculating some basketball data and want to easily return whether a team has played the night before or not. Here is a sample of my data: <tbody> date home team away team home team rest away team rest 4/1 bulls bucks y y 4/1 nets knicks y y 4/2 warriors bucks y n 4/2...

Hi, I was hoping someone might be able to help me with a VBA query. I have a workbook that my team update monthly with figures for their service levels. Each team member has their own sheet with cell ranges for each of their clients, and within these cell ranges are cells they populate with...

So, in swimming, you need to find the fastest relay team based on times they swim in each of the four events. So input is like: <tbody> Names Backstroke Breaststroke Butterfly Freestyle Kamlynn 19.63 24.59 19.26 17.02 Daisy 29.54 22.97 23.62 19.17 Vivian 30.43 33.81...

I'm trying to setup a list that totals 'points scored' by team and 'points allowed' by team. I can use SUMIFS to total the points scored, as I can total referencing the team name, but I'm having a hard time figuring out how to total the points allowed, as that teams name will constantly change...

I have the following data: <tbody> A B C D E 1 Team 1 1 Team 2 2 2 Team 3 2 Team 4 1 3 Team 1 1 Team 3 2 4 Team 4 1 Team 1 2 5 Team 2 2 Team 1 1 6 7 Team 1-Wins Team 1-Losses </tbody> Whenever a team wins, a 1 is entered manually into Column B or Column D...

....thought I would ask anyway. i have 5 different workbooks (data added by team captains) that feed into one table combined by a power query (viewed by team manager). Captains add data to their table and the manager can see this when he refreshes his query. All is working well. Now, is...

Hi All, I have a question in Excel/VBA. I am creating an Attendance tracker for about 200 team members; in which each row corresponding to a team member displays their attendance for the entire month. There are 3 types of leaves: CL, SL and EL. The last 3 columns of the table show the total...

Hello, I'm looking for an Excel Formula and I hope that someone can help me out with this? I tried to draw a simplified version of the Excel below. I'm looking for a dynamic formula which returns the required training level for a specific Team. For example: - For Team C - For Training 6 -->...

I have three columns with names. The first column contains members of team A, the second contains member of team B and the third contains the results. I want to count the number of winners from each team in the results column but I can't. Please help me.

Ok first I will apologize cause this is not just an Excel question. I have Excel workbooks linked to each other on a file share. I wan to move them to TEAMS which essentially is SharePoint on the backend. The question is how do I link sheets form one file in TEAM A to a file in TEAM B? I can...