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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top