person

Using VBA in Excel, it is possible to control Outlook but to what extent? The problem I have is as follows: Suppose Person A e-mails Person B. The e-mail contains 1 Excel workbook, along with a pdf and a Word document. When Person B receives the e-mail, they can: Accept (in which case...

Hey guys, So I have a list of total monthly salary for each person. The trouble is each person is split among 16 jobs with various percentages. Is there a simple formula to sum all of the salary devoted to each job without building out monthly calculations for each project? My data is arranged...

Hi I think I have created my spreadsheet incorrectly as I am trying to create a trend analysis comparing one financial year to the previous year, but also over a period of 12 months (hope that makes sense. I have tried the Insert Line Chart and that's having a fit <tbody> Name Jan 2017 Jan...

Hi All, Another noob Access question: I have a table set up: Dept ID#, Last Name, First Name, 01/01/19 (YES/NO column) For each person, I'm checking "YES" if they were there on that date. The dates could be a couple days apart or weeks, you never know. So, basically, this is an attendance...

Hello - I'm trying to calcuate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level. <colgroup><col><col><col span="5"></colgroup><tbody> Fee...

Hello - I'm trying to calculate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level. <colgroup><col><col><col span="5"></colgroup><tbody> Fee...

I am trying to create a formula that allows a set of data to be interrogated and then extract and display in set pattern. The data set will cover thousands of rows, for simplicity I have cut this to 15 with three columns <colgroup><col width="64" style="width:48pt"> <col width="76"...

I'm trying to rank some stats. The problem is that I don't want to encourage blind use of a particular work related function, and so I only want to count up to 100%, anything over 100% should be considered as 100%. However I also need to display the actual results still, so I cant just edit...

I have a sheet where multiple people add tickets every day I am trying to count the number of entries made by each person on each day Co column I has the person who created the entry and column O has the date, any ideas?

Hi All, I have a sheet with names across the top and then training records for each person below their names. What function/formula do I need to use in order to return a yes/no value if a person has completed a particular training course? Thanks in advance.

I have some data in columns that is separated by commas: person1, person 2, person3, person4, person5 person6, person7, person8 person44, person9, person10, person 99 etc. I want to be able to insert an "and" after the last comma so it would read: person1, person 2, person3, person4, and...

Hi all, Per below example, how can I design a macro that when clicked, will calculate the values in Column D, such that the current percentage reaches 50%. In below example, to achieve 50%, the sum in Column B should be 15/30, meaning I am lacking 6 hours (from the existing 9 hours). The macro...

<tbody> JOB PERSON ISSUE One TPK A One TPK A Two TPK B </tbody> Is it possible to change the colour of a cell if the values from both the 'PERSON' and 'ISSUE' columns match up. So because there are now two rows meeting the same criteria, I want the cell with person in it to change to...

I would appreciate any help to create a mechanism to distribute assignments to a group of people. 10 People 22 Assignments (same assignments monthly but not repeated by any one person until has done all 22) 10 instances of each (same) assignment to be done by each person OK that people be...

<tbody> Name Org Day Start End Minutes Incorrect Person 1 A Monday 5:05 pm 6:00 pm 0:55 0:25 Person 2 B Tuesday 5:05 pm 5:15 pm 0:10 0:10 Person 3 C Saturday 6:15 am 2:50 pm 8:35 0:00 </tbody> Hello all, Hoping someone can provide some assistance with...

Hi, I hv some amount like 25000. and I want to divide it on 9 employee. It show result in point like 2777.78 I want result without points. Like if I give 2778 to 7 person and 2777 to other 2 person. with this I can easily divide amount on all 9 employee. if there is any formula which I can...

Hello, I need to count the number of times the letter C appears in a range of cells but i need to excelude the duplicate values out of that count. Let me explain this better: <tbody> day1 day2 day3 day4 day5 day6 day7 day8 08:00 16:00 a a b 16:00 24:00 b </tbody> in this...

Hi all, I've set up a leave calendar where we add the staff requests row by row. To the right of this there is column for each day of the year. In each of these cells there is a calculation to work out if that day for that person is a true holiday (populates the cell with data from another...

I have a table of production and I would like to be able to show one person how they compare to other doing they same work without showing the other names. For example: steve compare to person 1, 2 ,3 and mary person 1,2,3 without making a separate table for each person.

I'm working on a nutritional project and I want to determine the average KiloJoule intake per week out of a large food intake survey. Therefore, I want to sum the values of K for each person entry (column A). For example, I want to sum I for rows 2:5 as these are the different ingredients that...