team

Hi all, First time posting and looking for some help regarding a set of sports statistics. I am looking to analyze the effect of home court advantage in the 2018-2019 season and wanted to be able to control for how many wins each team has at a certain time in the season. I currently have a set...

Hi Team, I have data like this and im using formula =IF(C3<=E3,"","FALSE") to get the result in column D. I want column D5 to display a message stating no data if date in E5 is blank rather than false. Could you help? <colgroup><col><col><col><col><col></colgroup><tbody> Column A Coulmn B...

Hi all, i'm new to vba work and i'm looking for an help! Question: In x path, on daily basis my team member saves the folders with loan number and today's date ex (7894561023 6-1-2019). they can be more than 25 or some times none on single day. so i want to copy the based on latest date...

Hi. I have a table containing staff member names (column A), team they belong to, which is numbered between 1 to 30 (column B) and contact info / location info in columns C and D. The whole range is A4:D434. What I'd (ideally) like to do is have a Userform pop up and show all of the staff...

Hi - I have a number of tabs detailing team results in month order Jan in A2 Feb in B2 etc Then an on another tab I have the monthly results in month order team 1 team 2 team 3 etc for Jan in Cells A2 B2 C2 etc However each month I have to copy the formulae into the monthly results tab or...

I'm trying to make a fantasy football draft tool. I want to take a ranking system from one page where the players are listed as Patrick Mahomes KC (12) and match them to players already on a team through another website that are listed as Mahomes, Patrick KCC QB. And then remove those already...

hi, if 496 hours per month and actual team cost is $6895.38 per month and this arrives to $13.90 as my hourly team rate. What would be my team cost per month is the total hours 785 during the month? Please let me know how do i calculate the team cost in excel when I only have hours for the...

Hi Folks I am looking for some help. So in "Case" tab I have a list of cases the company are dealing with. In column "I" within this tab contains the name of the worker who dealt with the case. In a separate tab ("Team Sheets") I have all the workers in the company listed based on which team...

Get file below is link https://1drv.ms/u/s!AnJwxxiz0Ezpg8YaJybiTFXDUaN6tQ I have sheet call BYE WEEKS I have data validation with no repeat name after you pick team will not be there on rest data validation list. when you pick a team list start at end of list how i fix this that drop list...

Hi team, where do i get Datedif formula, in which version of excel?

Hi, Can someone please advise me how to use conditional formatting when you want to use to conditions in the same formula. Effectively a 'And' statement. So I want Team A below where it shows May 60% to be 'Dark Green' in conditional Formatting. The formula is in the 2nd table is the May value...

This is my first post on MrExcel and I really need a hand... I have a multi team game log where the dates are out of order and the data doesn't contain who played who so each team must be handled independently. I'm trying to figure out win streaks and current streaks "for each" team (Should I be...

Hi all. Newbie here, I'm trying to figure out a formula to randomly choose team matchups for an 8 team golf league. And...I'm completely drawing a blank. Can anyone help me? Thank you! Sandi

Hi! Can you please help me solve in getting the row and column name given the value from a two dimensional matrix table? Here is the table I am trying to work on: <tbody> 1 C D E 2 Team1 Team2 Team 3 3 Task 1 Code1, Code 2 Code3 Code1 4 Task 2 Code2 Code1 Code 2, Code 3 5 Task 3...

The issue that I am having is, is that I have names in one column and the team they belong to in another. I would like to auto populate the team the name belongs to. However, the way the names and teams are broken down I don't know how to make it work out. I have provided an example that would...

https://imgur.com/r5isISk hi everyone the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is...

I've tried to find another thread that deals with this topic, without success, so here goes: I have a very large block of data: thousands of rows by hundreds of columns. I need to identify a known value in that block and return the value two cells to the right of it. I can use INDEX to...

Looking to populate a fourth cell based on the values in three other cells, If A29 is blank and B29 is "green" and C29 is "red" the I would like cell D29 to be "Team B" otherwise I would like cell D29 to be "Team C". I am unsure how to write this formula.

Hello, I am relatively new to excel. I want to create a function that will search for a name and result the heading (team). <colgroup><col><col><col><col></colgroup><tbody> Capitals Wizards Nationals Redskins James Corey Hannah Test1 Mike Amy Test3 Test2 </tbody> Each heading will...

I am trying to do an if statement based on another if statement: So if someone is In a team I want the formula to do another If statement based on this. Below is my current formula: =IF(C2<54%,"1",IF(C2>=80%,"2","3")) But I need to repeat this if statement 3 times as I have 3 teams with...