terry

  1. K

    Minimum value and date it occurred against a person

    I have a simple table showing a list of golf scores with the name of the person and the date of the round. From this list I want to be able to put in a separate table the date and lowest score of each of the players Name Score Date Name Date Best Score Terry 73 01/05/2019...
  2. M

    Merge rows keeping all data

    Hi, I have searched for this elsewhere but cannot find a solved solution. In table one I have the data as it would be, in table two I have the data as I would want it. Can anyone help? Name Surname Org Title Team 1 Skill 1 Skill 2 Skill 3 Skill 4 Skill 5 Skill 6 Skill 7 Skill 8 Gender In...
  3. B

    Lookup need help

    <colgroup><col width="64" style="width: 48pt;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="2"> <col width="64" style="width: 48pt;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;" span="7"> <tbody>...
  4. CyrusTheVirus

    I'll admit it... I'm stumped!! Need hierarchy help.

    This is the first time in my professional career that I am unable to figure out how to use features/formulas (i've never needed VBA, until maybe now) in order to solve a problem. Basically i need to create a certain formatted hierarchical structure based on the below table. I need each...
  5. D

    Return a specific cell if two criteria is met

    <tbody> Grade Name Date Terry 00-01 James 00-01 Terry 01-02 Bob 01-02 James 02-03 </tbody> TABLE 1 <tbody> Date Name Grade 00-01 Terry A 01-02 James C 00-01 Terry B 01-02 James D </tbody> TABLE 2 Hey guys, I'm looking to write a formula in the 'Grade'...
  6. B

    2 questions

    Hi guys, I am fairly new to excel so I don't know very much. I have done A LOT of googling and trying to figure things out - and so far I have succeeded pretty well. However, there are 2 things that I can't seem to find the answer to (and honestly I have a difficult time understanding some...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top