team

Hello. In columns A and B (A2:B400) I have a list of all games in one season, home team is in column A and away team in column B. Columns C and D shows game outcome Win or Loss (W/L). I need a formula (or VBA) to count the number of current win/loss streaks after each game and to place those...

Is it possible to do this? I have this sheet <tbody> Team NAMES SCORE T1 JOHAN 1 T1 ANNA 23 T1 MARIA 3 T2 BENJAMIN 5 T3 OLOF 55 T1 LARS 16 T3 LISA 12 T3 OSKAR 5 </tbody> Id like to get the top 3 highest scores. of each team. I want to present the...

Hey all, we're banging our heads against the wall on this formula - every time we think we get it, it doesn't work properly in testing. Essentially we have two tabs, a reference (Team List) tab where there's a Team Name (column A), a Process Type (column B), and an Ownership Level (column C)...

Hello, I need some serious help. I am trying to track cleaning crews who come and go, cleaning buildings on an as needed basis. The buildings are identified by contract ID, address, and sector. The crews are tracked by date, the day of week they work and the hour of day they work. For...

When the data is entered in c,d and e in sheet 3 it immediatly updates the average column on the collation sheet. Is there a way to delay the update where the 114.833 value is until the data entry is complete for the three entries? As soon as the 104 is entered it changes the 114.833 to...

Picture of spreadsheet: https://prnt.sc/ly46pc Hi all, I Would like to be able to filter the data shown based on a dropdown in D5. The 3 options are the teams: Estate Planner, Advisor Team, Review Team (employee names have been blanked out for the image) When a team is selected in D5 I would...

Hi team! Is it possible to combine two formulas like below ones into one single formula? F1: =+IF($C$1="Jan";$B$27;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$27) F2:=+IF($C$1="Jan";$B$55;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$55) Thank you in advance!!

Hi Everyone, I have a data set of sales reps and their sales (date of sale, amount, team, etc). I also have a separate sheet which has goals for these folks for the full year. I've setup a pivot table and a line chart on the sales file that shows total sales for the year broken down by months...

I really hope that someone could help me with this one as I have tried to study videos and still have no idea how to do what I'm looking to achieve, an I apologise if I'm not explaining properly. I have master table of data that I'm looking to develop a report from: <colgroup><col...

Hi team, I was wondering if someone can help me with the following: I have the below report that I receive (thousands of rows). I want to pull out certain countries into another tab that are relevant to me. I wanted to use index/match to pull this information, however I am not sure how to do...

<tbody> Colleague TEAM Course id 123 Course id 124 Course id 125 Course id 126 Course id 127 Course id 128 Colleague 1 TEAM A Successful Successful Successful Successful Successful Successful Colleague 2 TEAM B In Progress In Progress Not Registered Successful...

Hi every one, I am proud to be getting help from Mrexcel team on my every intoxicated situation on handling excel sheets. Thanks team and now i need a help from you. I am doing pan card service for people. i am entering the booking date in excel, i need a formula to show the date, after 10...

I am looking for a formula that will display the last, second last and third last cells etc. in a row that have a text value in them. My spreadsheet contains the results of a sports team in date order across a row. The results are listed as "W" for win, "D" for draw and "L" for loss. There...

Please allow me to apologize in advance for my lack of knowledge and I would greatly appreciate your help. To be brief, I have a workbook which contains a few worksheets. One of which is a list of NFL teams (Team List) in column A. Each team has additional columns with data in columns B-F...

How can I make a formula to find what team has played Los Angeles Rams in week 1 and 2 and other weeks. I know you can use the vlookup formula in week 1 and use the vlookup choose in week 2 to see what team Los Angeles Rams played. I want to be able to make a formula that when I place it in...

Hi, I have a bit of a problem. Usually I manage to find answers and solutions in the older threads (thanks to everyone for posting answers on the site), but this time I was forced to register and post my issue :). I m designing an algorithm for a football game, the issue is statistics. It would...

I recently set out to make a very dynamic pivot table featuring multiple variables. The example below shows team data by status of testing. The main thing I need is to be able to see the grand total and also another field showing the % Complete dynamically in the pivot table. The goal is to...

Excel 2016. I have source data for a pivot table across multiple columns. The first column is a date, the subsequent columns are teams, and the values are a count of faxes a team processed, for each day. I'm trying to create a pivot table in which the dates appear across the top, summarized...

Heeeeey guys :) I'm hoping this is a quick simple one:) I have a user form with a combo box that allows the user to select a team name. The next combo box I want to populate with tasks based on the team selected in combo box 1. I also need to apply this same code to 5 more combo boxes. (The...