jane

I would like to combine records into a query. For example, the table would be Jane, Doe, teacher, math Jane, Doe, teacher, English I would like the query to have: Jane, Doe, teacher, math English

I cannot figure out what I'm doing wrong. I have the following data in one sheet 1-Jan Jim Jane 4 Mary Jerry John 7 Sally Mark 7 I am trying to get the data to fill in on another excel sheet, within the same workbook, that is setup like a calendar My expected result is: Jane...

I have 2 spreadsheets. One spreadsheet has the following: <tbody> Last Name First Name Social Doe Jane 123-45-6789 Smith John 111-11-1111 Appleseed John 555-55-5555 </tbody> And another Spreadsheet has a list of names (all in DB) with their address. <tbody> Last Name First Name...

Hi, I'm trying to use INDEX, MATCH and SMALL to return multiple results and having some difficulty. On Sheet1, I have the following data: <tbody> Study Investigator Study123 Smith, John Study123 Smith, John Study123 Smith, John Study456 Smith, John Study456...

I have over 6000 rows of data. I have sorted it so each person has 2 lines of data that need to be added together. Each cust has 2 rows of data that need to be combined, but I need it to return the information in each column Row 1 (Col A - D) = Headers A Cust No B Name C Type D...

I've got a worksheet in which each row represents a specific task. For each task, there will be at least one assignee and perhaps up to four assignees. I'd like to make a pivot table that will count the number of times each assignee has been assigned to a task. Currently, when I add each...

Hi All, I'm trying to figure out a formula to lookup using only the left part of the target cell. I could normally easily just add a column to the target, and use LEFT to isolate the characters I need, but in this case, I need to leave the target sheet intact. Thank you! EE Number EE Data 1...

Hello, I have data from which i need to extract unique list. i have everything up and running but my data has lot more rows n columns and excel takes forever to calculate it. Please suggest way to simplify these formulas to cut back on processing time or any if there is other way to get the...

i have data from which i need to extract unique list. i have everything up and running but my data has lot more rows n columns and excel takes forever to calculate it. Please suggest way to simplify these formula to cut back on processing time or any other way to get the desired dynamic list...

Hi, Wondering if this was possible. If i have 5 images on a userform, is it possible for them to be changed according to a dropdown. eg if each image was saved in the same folder according to a set naming schedule ie Peter1.jpg, Peter2.jpg, Peter3.jpg, Jane1.jpg, Jane2.jpg, is there a way that...

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

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

Hi all, I am trying to put together a solution to total the all time result between all unique player combinations. I have provided examples of my data in the first table below, and what I'm trying to accomplish in the second table. First row is column letters, so the second row is actually...

This is the kind of thing I am trying to do: 1. I will enter the names of people in column A of Sheet 1. 2. In column B of Sheet 1, I will implement a checklist with two options - Yes and No 3. I will select Yes for each person whose name I want to have appear in another column-based list that...

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

Please could someone have a look at this as its a bit too hard for me to code. On MY workbook Have 3 sheet Sheet1 = “Customer Records” Sheet2 = “Data” Sheet3 = “Dormant” I take data from an online web form and paste it in to Sheet2 “Data”. I then run the vba to sort the data...

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

Hi everyone, I need some assistance calculating regular and OT hours by day and week. Anything over 12 hours in a day and over 40 hours in a week. If the hours were already counted as OT for the daily over 12, they should not be counted for the over 40 hours for the respective week. This is an...

I am trying to create a rota in excel to balance staffing. Trying to create a spreadsheet where each member of staff has a duty rosta with all people in the list. Any Ideas on where I would start? Thanks in advance. <tbody> Zone 1 - (1 Staff) Zone 2 - (2 Staff) Zone 3 - (2 Staff) Zone 4 -...

Hello, There's several examples of "remove duplicates" and "remove duplicate and delete row" and "remove duplicate and delete row/copy row to new sheet". However, I want to remove all pairs that are duplicates to a new sheet. So if, Originals Rows that contain: Jane Jane John Jack Then...