person

Here's my simple VLOOKUP: =IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]Bob'!$E$2:$F$569,2),"") I want to use the same file for multiple people by using a drop down in A1 to get the name of the person, which is the name of a tab in another file, to do the lookup. There's a tab in that...

Hi I've searched and found several posts with users having the same issue, and I've checked my formula returns the correct range, but setting up a validation with the following formula allows free text, even though the option to stop if invalid entries made is ticked. To replicate this issue...

Hi Accessers! I have a table (People_Table) with personal data for each person listed in rows under the column "Name". I want to create another table (Attendance_Table) to enter the days each person attended a function and that uses the peoples' names from the "Name" column in the People_Table...

Hi, is it possible two have two keys for each value? Here's the problem I'm facing with. I have some balance sheets for different people with different dates in different worksheets and files. I want to extract certain data such as the numbers of equity or debt from balance sheet, and rearrange...

Hello, I have a spreadsheet with a column which lists the total of daily output in various categories (each one in a different row) for multiple people, and I want to be able to sum that output in a row at the bottom of each person's summary. I have a Total row inserted between the bottom row...

Hi all Every week i get a new report with over 600 employees. Each of them are asigned to a coach. (Column I) I have to select them and make a new worksheet per coach. So that every coach has a clear list. How can i automate this so that i can put the report on sheet 1 and that it...

Hi! I am trying to figure out the best way to do this. I have two access queries. Person 1 and Person 2. There is a checkbox for Person 1 to send to Person 2. When Person 2 is done, they would select a checkbox showing complete and it would go back to person 1. I am unsure of how to get the...

Starting a new project. Curious as to the best way to construct the tables. One table will have the contact info in it. The second table will have the vehicle information owed by the people in the first table. A single person can own several vehicles. Person A owns 1 car Person B owns 2...

I'm trying to automate the proces of making weekly work schedules for my employees. What I would like to achive is: input the names and number of hours each employee has to work in a week Set up rules, so that I have one person meeting at 6:30 where we open, one at 7 o'clock. Have one...

Hi All, In need for some urgent help. I have figured out how to SumConditionColorCells condional formatting cells. I am summing each working day for each month for 13 different names with 5 different conditional format rules. The only way this will work, is if the conditional formatting is...

Hoping someone can help. I am trying to match a name Column A for payments between 2 date ( Quarters- ie January 1st 2019- March 31st 2019) If the criteria match I need to know how many claims and the total payment for claims for that person in the quarter- There is generally more than one...

I have another task in excel that I must perform that I hope you'll will be able to help me with. Once again I am allocating limited money however, this time I need to allocated the same to everyone in increments until the pool is exhausted. So its almost like dealing cards. For each round...

Hi, I have been racking my brains for the past 3 hours trying to make a formula work for me. I have a table in which contains a Date From, a Date To, a persons name and then 2 columns for charge out rate (basic time and overtime). In my master sheet I want to be able to book a person at a...

Hello All! I am quite stuck and I am sure you lovely lot will be able to solve my mystery! So my aim is to find out which cells with a criteria of "Name" & "Date" are red. When a person is late, the cell which is a time, is colored Red. I have names in cells A, and the date in the header...

Hi, i am trying to produce a spreadsheet that allows me to view how many items someone has sold per month. i am using the below formula but it doesnt seem to be working. if i take the date ranges out then if works but it gives the overall sales the person has had. i basically just want to add...

Hi I have a workbook with two sheets. To the second sheet (sheet2) I have 20 people in, each person has 3 columns salary, income, expenses. On Sheet 1, I want to be able to enter a start date (A2) and an end date (A3). Then I want a VBA to search each person and sum the incomes between these...

Hi everyone! I have a list of programs and for each of them, a list of names that worked on the program, anywhere between one and four people. If I want to synthesize this data and know, for example, what programs should i ask "Geoff" about, how do I do this in Excel? <colgroup><col><col><col...

Hello, I've got a task given to me that's been quite manual in the past that I'm trying to speed up with the help of some vba/formulas. Basically I've got a list of products (A,B,C) with a manufacture due date that need to be allocated between 3 different people (X,Y,Z). The dates will differ...

Good day everyone. I could use some guidance. I have table that is used for people to pick dates they want to volunteer their time for. I need to translate the date from <tbody> Date 1 Date 2 Date 3 Date 4 Date 5 Date 6 Bob x x x...

Is there a way in a new column to group people in groups of 9? The first 9 people would be in group 1, next 9 people would be in group 2, etc? <tbody> Person 1 1 Person 2 1 Person 3 1 Person 4 1 Person 5 1 Person 6 1 Person 7 1 Person 8 1 Person 9 1 Person 10 2...