jane

Hello, I am hoping to get help with a formula that can calculate PTO accrued by a specific date. For example, If I wanted to know how much PTO Jane will accrue by 11/16/2019, what is that amount based on how many hours Jane receives in a year. Our current formula (below) doesn't work for...

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...

Hi all I have a column of data with Users names and a column of User IDs - the ID is to anonymise and not have the ability to trace an individual. So for example - 3 entries for John Smith; 1 entry for Jane Doe; 5 entries for Sam Brown.... so the 3 John Smith entries will have the same user...

I must, after pasting a long list of patient names, truncate to display only the first two letters of the last name, for privacy. Beethoven, Ludwig V must become Be., Ludwig V Doe, Jane X must become Do., Jane X I've been using this: =(LEFT(D66,2)&"."&","&(RIGHT(<wbr style="color: rgb(34...

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...

If I want to add/insert the name Mary (after each Larry) to the Excel column below, without typing in Mary about 10 or more times, what menu would I use? <tbody> Bobby Doris Jane Joe Larry Bobby Doris Jane Joe Larry Bobby Doris Jane Joe Larry Bobby Doris...

Good morning ... I'm not sure if this can be done, or even how exactly to describe it, but here goes ... I need to create a "ballot" file, which I will then refer to after generating a random number using a formula. I have a source spreadsheet with names and the # of ballots each name gets...

I have a very large table that includes thousands of rows. Row 1 is the header and I'd like to extrapolate each subsequent row to its own file, keeping the original header, and save each using the entry in column A. Could someone help me with a script to accomplish this? Original table that...

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 ...

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 need help with a formula or set of formulas to match 2 columns of names. One column will have first and last name and the second column will have last comma first name and sometimes a middle initial. How can I compare the 2 to match the data sets without the middle names, suffixes, etc. I...

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...

Hello. I am trying to figure out a way to have a single button send the user to google based on the content of a cell. For example. If F1 has JANE DOE... then once the button is pushed it would send the user to google and JANE DOE would already be in the search. I would think a simple google...

I am looking for a formula which can assign a code based on predefined criteria <tbody> A B C D E 1 Strategy Name Area Calls Priority 2 S1 Amy Bakery 0 3 S2 Jane Bakery 1 4 S3 Jane Bakery 1 5 S1 Amy Bakery 0 6 S1 Peter Bakery 2 7 S3 Peter Bakery 2 8 S2 Jane Bakery 1 9...

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...

Hi There, I need a way of transposing this data...12 columns, there will be about 200 rows of data... <colgroup><col><col><col><col><col><col span="7"></colgroup><tbody> First Name Last Name Region Manager Patch Q1 Q2 Q3 Q4 Q5 Q6...

<tbody> Quarter SR Client q1 jane abc company q1 jane mcg inc q1 jane mcg inc q1 house box llc q1 bob hti q2 bob hti q2 bob apple q2 jane abc company </tbody> I have this set of data. I want to do two things: 1. calculate the number of total unique clients by Quarter and SR...

<tbody> Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Lookup John Smith 12345 HoS Jane Simpson 3456 Another Name 9876 Hector Wilson 34523 etc etc 12345 Jane Jones 53425 Another Name 9876 Kelly White 19282 Adam Lewis 45455 etc etc 45455 Hector Wilson 34523 John Smith 12345...