jane

  1. LxQ

    Combine multiple records into one

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

    Nth occurrence of non blank is pulling in the wrong data

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

    How to compare and eliminate un-needed columns

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

    Index Match with multiple results with a twist

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

    Multiple column Balance Summarization

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

    Pivot Table: count multiple columns

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

    Lookup using the left portion of target cells

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

    Dependable Dynamic Unique List

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

    Help with dynamic unique list

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

    images on a userform

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

    Macro for Creating New Columns and Transferring Text

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

    Need help showing department names 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...
  13. S

    Count all time results for unique matches

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

    Conditional Inclusion of Text in a Column

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

    Aggregate text data into table

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

    Remove Duplicate depending on date and time

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

    Data Validation with =&E2 (cell reference)

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

    I need assistance with calculating Reg and Daily/weekly OT

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

    Creating a Rota

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

    Remove ALL duplicates, do not keep unique, and copy all duplicates to new sheet.

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top