# jane

1. ### PTO Accrual Formula

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...
2. ### Help! Consolidating rows across columns with duplicate names!

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...
3. ### Same user ID for multiple entries

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...
4. ### Truncating A Full Punctuated Name

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...
5. ### Formula for autopopulating sequence numbers upon change in names

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...
6. ### Insert row question

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...
7. ### creating new cells based on cell value in separate sheet

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...
8. ### Split each row into individual files

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...
9. ### code or formula to list results of duplicate values

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 ...
10. ### Un-flatten Survey Data

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...
11. ### Matching Names with different criteria

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...
12. ### Compare lists by partial match

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...
13. ### Replace data in Column A with macro code

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...
14. ### Index Double Match Offset

<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...
15. ### Button with link url based on cell

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...
16. ### Counting duplicates and assigning a tag

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...
17. ### Copy and Paste IF Cell in column is empty

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...
18. ### Transpose data?

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...
19. ### Counting Unique names only, based on a couple of criteria

<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...
20. ### Lookup Multiple Values across Multiple Columns and return the value in a new column

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

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
• Listbox Header
Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
• Complex Heat Map using conditional formatting
Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
• Conditional formatting
Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...