doe

I'm working on a mail merge from excel. On some pages, the data comes over and is mostly spaced evenly but on other pages is spaced all over. Is there a way to get all the spacing to be consistent on each page so it doesn't look so sloppy? I've tried to put the merge fields into a table, but...

Hi All Can anyone help me please with a formula for the following example. Ideally, I would like a regular formula, but if this is not possible, then a UDF would be much appreciated. I have the following in columns A, B and I would like the result to be as per column C (Owner Name) :-...

I have a spreadsheet of employees. Through a userform, I enter various updates on performance, status, etc. Each update is entered on a new line. An employee might be assigned to different departments. What I'd like is some guidance on VBA that will retroactively update all prior...

Hi VBA experts! I have a big data set that shows where individuals went on daily trips using addresses. One column contains the To address and one column contains the from address. Obviously if Row 1 says From Address A to Address B then you'd expect Row 2 to start with From Address B...

<tbody> A B C D E F 1 Customer Name Customer No# Order # Order Price Order Date Description 2 John Doe Cust001 1000item $1000 2011/01/01 Laptop 3 Jane Doe Cust002 2000item $2000 2012/01/01 Monitor 4 John Smith Cust003 3000item $3000 2013/01/01 Motherboard 5 Jane Smith Cust004...

Hi peeps! I'm trying to nest a double vlookup with a search function to search partial words. Any help! A B C D E F 1 Customer Name Customer No# Order # Order Price Order Date Description 2 John Doe Cust001 1000item $1000 2011/01/01 Laptop 3 Jane Doe Cust002 2000item $2000 2012/01/01...

Hi Experts of Excel! Please help me if you can! I am a complete Newbie and addicted to Excel. There are 2 Components to my problem, and I think there is surely a better way to achieve it! I will set out the Raw Data Template first! Part 1...

Hello! I'm trying to write a macro to create five new columns (after column F), give the headers specific names, and transfer text after line breaks from column F. For example, a cell in column F may read: John Smith Jane Doe George Parker Michael Scott I would want John Smith to remain in...

<tbody> A B C D E F 1 John Doe 2 235 west street 3 Anytown 4 CA 91001 5 555.555.1212 6 7 111 North 8 Jill Doe TX 9 SomeTown 10...

I am trying to get total customers with an order time before(less than) 12:00 PM. So I extracted data from our system and was able to do asave as, and saved my data as an EXCEL report (.XLS) Order time and discharge time had 4 leading spaces in frontof each time. So I created a new column...

I have a report that shows people names First Name Lastname (Dept) I have a different system that needs people as Lastname, Firstname (Dept) - if applicable. Note - not everyone has their dept name. Just if there is more then one person at the company with the same name. I've found formula...

Hello, I have a spreadsheet that contains several columns similar to the below: <tbody> A B C D E F G 1 Report Date: 6/22/18 2 First Name Last Name Category Sub Category Reg Code Dist Code Area Code 3 Jon Doe Fruit Apple 11 000 00 4 Jane Doe Fruit Apple 11 001 00 5 Jack Doe...

Hello All, I am using MS Access.... As I run the data, I have each client's appointments listed (1st, 2nd, etc.) I need a total count of appointments for each client (Number of Appts)... I know how to create a count in Excel, but not sure how to attempt this in Access... How do I add a...

Hello, I want to create an aggregate data table (similar to a pivot table result) that shows text values, not numeric. I have a number of rows of data that show an individual ID number, name, district, and grade - see sample table below: <colgroup><col width="64" style="width: 48pt;"> <col...

Hi, I am trying to integrate this, I have 1 client with their latest appointment on 1 row. How would I do this? <tbody> A B C D DOE, JOHN 02/14/2018 3 mos. 01/01/2018 DOE, JOHN 02/14/2018 3 mos. 05/01/2018 DOE, JOHN 02/14/2018 3 mos. 03/21/2018 A B C D DOE, JOHN...

I need to calculate a customer's age based on their date of birth (for example 8/10/2017) and a past date of service (2/28/2018). Basically, how old was each customer on 2/28/2018. What formula would I use? <tbody> A B C D DOE, JANE 08/10/2017 2/28/2018 0.6 DOE, JACK 1/10/2017...

Hi All, My data is supposed to look a certain way ( see below) I need to remove spaces between D, the ID # (for example DXH110817) and the last name Doe. I'm trying to find an efficient fast way of doing this since I have about 50 records in my data. Any suggestions? So right now, it...

Hello Everyone, I am trying to use Conditional Formatting... Our goal is to have clients with viral load results less than 200, When a client's viral load lab result is greater than 200, there should be an X in front of the lab results (see below) When a client's viral load lab result is...

I am trying to replicate the following formula in Data Validation: ="Call"&E2 ="Email"&E2 I am entering a name into cell E2 - let's say Jane Doe. I want the data validation to read in a LIST: Call Jane Doe, Email Jane Doe I would typically just type: =Call Jane Doe,Email Jane Doe in the data...

I am trying to remove the salutations from an excel column. The column contains random data. Some names have prefix "Mr.", "Mrs." and some have nothing before the. For example: Ms. John Doe Mr. John Doe John Doe What can I do in this case to remove the "Ms." and "Mrs." without affecting the...