james

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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