team

  1. R

    Finding the latest saved sub folders in the folder to copy and paste to another folder on daily based work

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

    Finding / Listing all Members of a Team

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

    Formula copy

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

    Not sure if this is possible......BUT

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

    Calculating costs in Excel

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

    Look at mutiple columns and return column header where the text matches

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

    Help with data validation question

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

    where do i get Dateif formula

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

    Conditional Formatting using an If and statment

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

    Tough Winning Streak Formula

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

    8 team Golf Schedule - need formula to choose teams

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

    Find Value in matrix Table and return column and row names

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

    Lookup formula

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

    help with efficiency on football database

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

    INDEX MATCH when the target column is not known

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

    If-and-isblank

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

    Function to result column header based on text in a column

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

    IF Statement

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

    Locating a value based on column header name instead of Column Number

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

    Need Code for copying/pasting irregular data from one workbook to another

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

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top