bob

Hi, I'm kind of lost - I am able to do an IF and VLOOKUP to get the required data but now i am trying to add another IF and VLOOKUP formula to multiply by the discount rate if the purchase if made before the discount end date. I'm really struggling to grasp on the best action to achieve these...

Hi, is there a way to look between a specified date range and return the names that have 3 or more records. For instance in column A is the dates and column B is names 21/03/18 Bob Smith 21/03/18 Jane Doe 22/03/18 Lois Lane 22/03/18 Clark Kent 23/03/18...

Hi All, longer time lurker (thanks to those who have "stealth" helped me when I've come across posts via google) first time poster. I'm trying to create a daily report to log work volumes by employee with each employee having a tab and a line of data added for each day to said tab. I'm sorted...

I tried to search for this and was unable to find it. If someone knows of an existing thread, please link me to it as I don't wish to recreate the wheel. I am trying to create a formula that takes the name in table 1 and looks it up in table 2. If it finds that name, it should look up the...

Hi all, I have a rather peculiar problem. I have created a simple OT tracker. [/IMG] I want help in generating the data for the last two columns. Dates Worked Normal OT should tell which are the days a certain employee stayed back for OT on a weekday. So for example for Bob, this column will...

Hi, I'm not sure if this is possible but I am trying to count a combination of two cell values (Concatenate function) and if there are any reciprocals as one. Example: <tbody> A B C D 1 Player 1 Player 2 Combined Player Count 2 3 Bob Joe Bob&Joe...

I'll do my best to phrase this - I have a table, see below. I have a table similar to below, in cells A9 and B8, I want to be able to edit the names to any of the names in the table, and have it return the appropriate value. E.g, If I change the names to Bob and Pete, it should show the value...

Below is a mock example of my spreadsheet. Column B has the names of Tutors who deliver training hours to the Students listed in Column A. And Colums C1:I1 have all the dates for every month (showing is just 23Jan-31Jan). SS#1 <tbody> A B C D E F G H I 1 Student Tutor 23-Jan 24-Jan 25-Jan...

Hi all, I'm not even sure if this is possible but I just wanted to see if there was a better solution to something I am struggling with. I am trying to remove duplicate instances from a list of training attendance. People are free to book on a course themselves but the problem from a...

Hi Everyone, I'm trying to work on a formula which has me stumped. I have a table which contains Names in one Column(A), and Dates in a second Column(B). I only want to return column B DATE if the Column A Name is Bob But it has to be the last Row that has Bob in it i.e. A B...

I am trying to look at a user log data set and assign a team based on the user name and the date. I have a seperate table with user names and the dates they were on the different teams. VLOOKUP will find the first entry for the user but I can't figure out how to have it also look at the date...

I am currently working with a list of 20K plus names. Each name has a "supervisor name" associated with it. However, I am trying to utilize this formula to show all people under specific supervisors when one is listed...

I cannot figure out how to extract this from all the other examples I find here. (Great site, thanks everyone!) Text A1: Bob Smith ~ 123 Main Street ~ Houston ~ Texas ~ 77001 I need: B1: Bob Smith C1: 123 Main Street D1: Houston E1: Texas F1: 77001 Thank you!

please help:rofl: i need a formula that will assign a id number if the 3 coloumns match i have 700 lines of data each week to sort INPUT <tbody> id customer area address bob 1 blue lane bob 1 blue lane bob 1 red lane peter 2 blue lane bob 1 blue lane...

is there a way I can have a space in between the cells I'm linking? for example if the name Bob is in A1 and Smith is in A2. I want A3 to say Bob Smith instead of BobSmith Thanks

Howdy- I'm needing some help with something i'm not sure how to do. I have a 2 cells (text values) that has names (i.e. Bob and James), i am needing a way to have these values swap each week for example. If this week E5 is Bob and C7 is James, i need for it to next week automatically switch to...

I have a report that shows each line item on open orders as it's own row. So let's say there are 3 orders with 3 items each. The report would have 9 rows and might look something like this: <tbody> Order # Order taker Item Qty 123 Bob stuff 2 123 Bob stuff 2 123 Bob stuff 2 222 Jane...

I'm losing my mind on something that I feel should be quite easy. I'm trying to convert data from 1:Many, such as the attached sample image. For example, lets say I have data like this: <tbody> Person Item Bob Bananas, Apples Carl Oranges, Kiwi, Chocolate </tbody>...

Good morning and thanks in advance for your help. I am trying to figure out what function to use and how to write a formula that will tell me If Bill Bob worked during week 1, and his name appears on the list of those that worked (sheet1!A:A), and that week has four 8 hour days as indicated in...

I have a table which contains schedules for my employees, broken out into their start and end times. Like so: <tbody> Employee Monday_Start Monday_End Tuesday_Start Tuesday_End Bob 09:30:00 18:00:00 09:30:00 16:30:00 Alice 08:00:00 16:30:00 08:00:00 16:30:00 </tbody> And I...