doe

Hey, I've tried to look through the forum and see if this has been asked, I haven't found anything quite like what I'm looking for - Basically, I have information from a school. Column A is school ID, column B is a students name. Columns C through I have information regarding a particular...

<tbody> Name (Column AD) Category (AE) Total Hrs (AF) Pay Rate (AG) Wage (AH) John Doe 1 TT Field 12.5 <tbody> $104.55/hr </tbody> <tbody> $1,306.88 </tbody> John Doe 2 TT Field 4 <tbody> $104.55/hr </tbody> <tbody> $418.20 </tbody> John Doe 3 Field 15 <tbody> $34.85/hr...

This site has helped me in years past and am stumped again. I have a spreadsheet of many rows. Column A is list of names Joe SMith Joe Smith Jane Doe Jane Doe Jane Doe Rick Smith Rick SMih I want to be able in column B to put in a sequence number so that both Joe Smiths end up sequence 1...

Apologies in advance. This is my first time posting. I have a list (DATA A) with two columns of data, Name and Account. I am trying to match the account numbers from Data A to a separate list (List B) which contains names, but where the names are separated into two separate columns for First...

Hello! I feel like I am sooo close to figuring out this formula or conditional formatting but just can't quite get there. Its simple... per a collective agreement, any of employees that take their breaks "late" or don't take them at all are entitled to pay at 1.5x for that break. I get an...

Good day We have delivery drivers that train new employees and we incentivize them forthis. A report is printed out weekly that has the drivers name in A, the routename in B, and the date in C. Is there code or formula to list the drivers thatran the same route on the same day? Example ...

Hello, I am trying to pull phone numbers on an excel sheet using the vlookup function, unfortunately - there is no unique identifier that is correct. Example: one persons name may read "John Billy Doe" on the one page but on the line with numbers it reads "Doe, John" or "Billy Doe John", "John...

Re: Hiding password characters Hi everyone, I am using code to produce a password box on opening a workbook, so far so good it works fine my only problem is that it shows the password it does not hide the chatacters using an astrix " * " please see code below any help to just add some code to...

I have survey data that requests responses from parents about the number of kids they would like registered for an activity. <tbody> Parent Name Child 1 Name Child 1 T-Shirt Size Child 1 Birthday Child 2 Name Child 2 T-Shirt Size Child 2 Birthday Child 3 Name Child 3 T-Shirt Size Child 3...

I am looking for an excel macro code to do the following: If the name "Jane Doe" is in column H then I need the name "John Doe" dropped into column I. Thank you in advance for any help provided.

Hi, Please HELP! I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell. TAB 1 (ColumnA) (ColumnB) <tbody> Name Amount Anne OFF Amy Mike Doe OFF Anne...

Hello, I have a list of names in 1 table and a list of names in a 2nd table. I want to highlight every line in the second table where the person found in the first table, however there could be extra words added to the names in the second table. Example: Table 1: John Doe Jane Doe John Smith...

I am looking for help with macro code please: I have a spreadsheet and in column A there are multiple company id numbers and in column C there are different employee names. I would like to take the name in column C and drop it in column A so for example: If Column A has number 12345 and...

<tbody> Employee: Jane Doe Regular $68,000 Vacation $1,000 </tbody> Hi Excel Experts, I need some help w/ Index Multi Match Offset. As you can see A1 is Employee: Jane Doe and B2 is $68K. I need an index double match offset formula that will look for Jane Doe and Regular and gives...

Column A has an Employee Name Column B has a Date An employee name can repeat on the same date I want to know by month the sum of the count of the number of unique names each day. John Doe 4/2/2019 John Doe 4/2/2019 Jack Smith 4/2/2019 John Doe 5/1/2019 Jack Smith 5/19/2019 Jack Smith...

I need to look up the sup total or Over time based on the name. Example i want to put Doe, John in a cell and have it bring me 0.77, any ideas? <colgroup><col><col span="4"><col><col><col span="3"><col><col span="3"><col><col span="2"><col></colgroup><tbody> Pay Date Pay Code...

I am having a problem with trying to make sure that i do not have any duplicate names on a worksheet as well as on any other worksheet. I have 13 Sheets and if John Doe appears on one of the sheets I would like for it to turn red to indicate that i have a duplicate on other sheet. Is this...

Hi I need a code that will copy and paste data from column D to column B if column B is empty, the code will ignore any empty cells in column D and move to the next cell with data to copy over. From this <tbody> A B C D JANE JANE DOE JOHN DOE JOHN DOE JANE JANE SMITH JOHN SMITH JOHN...

Good morning all. I am not all that savvy with excel and am attempting to create a form that will auto fill from another spreadsheet when given a few criteria. On the column header is dates from the first of a month to the end. On the Y axis are names. In the data range are letters denoting...

I am wanting to count the number of personnel within a defined name. I have tried using =COUNTIF(A1:A5,_OFF) "_OFF" is the defined name having various titles in them. The overall outcome of the formula I am needing help with is to show there are 4 doctors of the entire range using the _OFF...