1. R

    Line Manager Formula/Macro

    Hi, I need to build a report that can look down a list of line managers and determine the employees that sit under them whether directly or indirectly. For example, the CEO may have 5 direct reports and each of those reports have a further 20 reports. The formula would need to return the...
  2. H

    Index Match

    <tbody> 1 MIKE HAT JIM BAT JAMES BAT BOB HAT 2 BOB BAT JAMES HAT BILL HAT 3 JIM HAT 4 MIKE BAT JAMES HAT BOB BAT 5 BILL HAT MIKE HAT </tbody> above table Column A is day of month column followed by names than code to the right for each person. on another sheet I have the...
  3. E

    Sending emails from excel based on row - Urgent

    Hi Team, I have a data as below and the data starts from row 3. Row 1 and 2 are headers. What i want macro to do is to create a new workbook for respective user and draft an email with standard text from outlook. In below example for James there should be 2 emails generated because the name is...
  4. J

    duplicate rows

    I have had this question before and the macro does not work any more any suggestions the top half is single and the bottom half is where I want to get to. <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> 25...
  5. C

    please help with excell formula

    I would need to have the formula to reflect the below match in colums C Thanks <colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody> ID Name Match 88100 james TRUE 88100 james TRUE 88100 Mick FALSE 89100 John TRUE 89100...
  6. I

    calculation help

    Hi Guys i have the table below with some results the score seems to be incorrect i am not sure if its my formula <tbody> a b c 1 Name Result 2 James 2% 3 Alex - score 20 </tbody> the formula i use to get the result are as follow for both james and Alex...
  7. I

    help with adding max date

    HI Guys i have a countifs statement that is doing the on the below set of data <tbody> Name Status date Alex Qualified 30/03/2019 Alex Qualified 30/05/2019 Alex Qualified 30/04/2019 Alex Not Qualified 29/04/2019 James Not Qualified 26/04/2019 James Qualified 26/04/2019 James...
  8. I

    Count ifs with date range

    HI Guys i am trying to create a formula where it does a count if the date range condition is matched else bring back blank, below is the data <colgroup><col><col><col><col></colgroup><tbody> Name State Created On Alex Qualified 30/04/2019 Alex Qualified 01/05/2019 Alex Qualified...
  9. P

    SUMIF On Column Where Single Column is Primary Key for Numerous Criteria?

    I couldn't come up with a clear title. Here's the question with a proper example. Two Tables of Data: TABLE A <tbody> Name GP M P A R James 80 3040 2320 880 480 Steph 72 2448 1800 576 288 Kevin 73 2555 1971 511 511 Chris 78 2730 1404 780 234 Patrick 80 3200 1760 160 960 </tbody>...
  10. O

    "sumif" help

    Hello there, Please assist Please I need a formula that reports how much cookies James sold between <tbody> 03/01/2019 and 09/01/2019. See table below <colgroup><col><col><col></colgroup><tbody> <colgroup><col><col><col></colgroup><tbody> A B Salesman Cookies...
  11. D

    Name in different ways captured

    Good Day, I am hoping there is someone that can help with a formula. The problem is the data is not captured constantly. So i have a name that gets captured in 3 different ways I need to find the value of this person for a specific month. Please if there is formula that I can use would be...
  12. J

    this ones to complex for me

    Sheet 1 holds all the information. Sheet 2 is going to be a kind of chart that I want to be auto created. on Sheet 1, Column A is the names, Column B is the Column # on sheet 2, Column C is the starting row # on sheet 2, Column D is the amount of times I want the name to be repeated...
  13. O

    Countifs with repeated values

    Hi there , Please help <tbody> month worker month no of workers Jan john jan ? Jan james feb ? Jan james Feb james Feb james </tbody> i need a formular in the cells with question marks. The formular should return the number of workers in each month. Eg January should...
  14. E

    Counting continuous duplicates

    Hi Team, I have a below data and we would want to know how many time word P has repeated continuously for each name. I have give the result which I require for Jack it should be 4 (Its repeated 4 times continuously) and for Jill it should be 2 (Its repeated 2 times continuously) and for James...
  15. 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>...
  16. J

    Formula Help

    Hi I use the following formula which works well =SUMIF(CAR!$D$43:$D$907,$B4,INDEX(CAR!$H$43:$XFD$909,,MATCH(TODAY(),CAR!$H$42:$XFD$42))) How do i add the following 2 formulas to the formula above so it sums the 3 tabs? I am hoping for a single formula...
  17. S

    Getting the same value twice with VLOOKUP

    Hi, I have a list of players & there rating & there all ranked highest to lowest. But, when there are 2 players that have the same rating it only shows the top one, how do i get it to show the next one? Example: <colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt"...
  18. G

    Assistance with Excel Index's

    Hi All, I was wondering if anyone could help me, i have a list of people, and payments. for example : <colgroup><col><col></colgroup><tbody> Eddie 10 Steve 12 Steve 65 Steve 12 Steve 12 Steve 35 Steve 56 James 66 James 73 James 21 James 33 James 21 James 21 James...
  19. T

    Help with a formula

    I am looking for some assistance with a formula. I need it to say if there is text in g11 through g15 I need it to calculate 192*(each field with a text entry) in cell H22. Example: (This would be 192*3 since three of the 5 cells have text so H22 would read 576) <tbody> James Nancy...
  20. 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'...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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