doe

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Hello, I am looking for a formula to convert a full name in the various formats seen below and convert them all to a consistent "last name only" cell in an adjacent column. I've been trying...

I don't know if I need to use VLOOKUP, INDEX, MATCH or a combination of them. I need to get the employees review dates from Sheet 2 into Sheet 1. The dates on Sheet 2 are in a row, and I need them on Sheet 2 in a column, but I need them in the correct month. So using Sheet 1 A3 as an example...

Hello. I have a bit of an issue. I am trying to combine a first name and last name with a comma in between. For example, I need Jane Doe to become Doe, Jane. Cell C1 is Jane Cell D1 is Doe I have used these formulas: =D1&","&C1 =CONCATENATE(D1,",",C1) In both cases the result is: Doe...

Good day, I'm trying to use a formula to change the name and bring in the correct format into the appropriate cell, but I can't seem to find the right combination? Example: Data in cell B1 = Doe, John (John D. Doe) my formula gives me = John Doe (John D. Doe) "=MID(G25&" "&G25,FIND("...

Hi All, I hope you're enjoying the weekend. I wonder if anyone can help with the following formula. I'm trying to pull a date from another table but only if it matches certain criteria. Table with Data <tbody> Unique Identifier First Name Last Name Course Date Grade 12345 Jane Doe Course...

Hi I'm trying to create a formula that says count the number of rows where the Value in column Dn is not blank and the value in Colum En = "X" Like this - where x = "Prawn & Crab ****tail" =COUNTIFS(LEN(NAME),">0",Starter, "Prawn & Crab ****tail") Expected answer is 1 <tbody> <tbody>...

What I am trying to do in a single formula is 1. Link to a sheet that has not yet been made 2. Pull the text from a cell to reference that sheet 3. take data from that sheet and put it into the cell with this formula. Sheet Cell Content List A1 John Doe John Doe...

Hi All, I'm looking for a formula to Count Individual Occurrences that are consecutive for the days of the week I have a list of names on one tab and I want to look at another tab and do the following: 1.) Count individual occurrences that are consecutive for the days of the week 2.) a new...

I have a column of information and would like to find a way to translate it into rows using VBA. Every 3-7 rows in my existing column has a cell "New Record". I'd like the information below that cell to be laid out in a new row. Currently: <tbody> New Record 4756 John Doe 123 Street...

Hello, I have a list of names that I will be using the CONCATENATE function on. However, they have to be in a particular format. Example: Column A1 has LAST NAMES Column B1 has FIRST NAMES Column A already has all of the Last Names IE "Doe" in A1. What it needs to look like is Doe, (Doe...

A21:A30 are locations C32:C2000 has names of locations G32:G2000 has a dollar amount H32:H2000 has a dollar amount I need B21 to only count locations in C32:C2000 that correspond to A21 and have a value in either G21 or H21. Example C32 is "Home". The formula sees that A21 is "Home", but also...

I've got a list of people working throughout the day on Sheet1 <tbody> A B C 1 Name Start Day and Time End Day and Time 2 Jane Doe 11/01/2017 07:00 11/01/2017 12:00 3 John Doe 11/01/2017 08:00 11/01/2017 10:00 </tbody> and would like to convert data into a timeline spreadsheet...

Hi all, hope anyone can help me with this. I have three names separated by comma in one cell C11 (John Doe, John Smith, Joe Strong). I would like to split the names and have them transferred to cell B8, B9, B10 on a different sheet (from Fest Info to Front). So John Doe will end up in B8, John...

I have cells that have names, I want to write a formula to from the right and find the space and return the last name only. Example Cell A2 has John Doe I want a formula in Cell B2 that brings back just Doe.

Sorry guys, I've done this before but cant get it to work this time I have a name as such John,Doe but I need an extra space after the comma as such John, Doe Please assist

Hi, I have been working on this for more than 4 hours and reviewed so many formulas online. I need to create a mail merger with multiple rows. Here is the sample data, I have more than 700 individual employees on the sheet. I need to show on one page per employee all the applicable Bonus plan...

Good Afternoon All... I have a column with names and SSN's, as such John Doe: XXX-23-6789...I want to extract "XXX -" and be left with "John Doe: 23-6789". Thank you kindly Benny Torres

Hi Guys, Hoping someone could help me. I'm using Excel for Mac 15.39. I have a spreadsheet with two sheets, shown below: 1. Calendar <tbody> 23/10/17 24/10/17 25/10/17 26/10/17 27/10/17 30/10/17 31/10/17 01/11/17 02/11/17 03/11/17 more dates ---> John Doe Jane Doe...

sorry for poor title! If i have Names in column A, then a Rating (1, 2 or 3) in column B....Lets say JOHN DOE is listed in column A, 8 times. I want to find out if all his ratings are the same in column B. Column C just needs to indicate that not all JOHN DOE's ratings match. Hopefully...

Hi everyone, i have to run a weekly report with diffrent cases. Each case has an approval path and must be approved by 6 persons. I have to find all the cases which have John Doe in the approval path, either is he the first approver or the last, this does not matter. If John Doe is in the...