combine lists

  1. M

    Combine 2 lists into 1 w/ no duplicates. Formula/function only.

    I have 2 timesheet lists that are delivered monthly, and the length varies significantly each month. I need to form one list that shows all of the people from both lists... without duplicating if someone is on both lists. I have written a formula that works, with one little hiccup. There's a...
  2. S

    Combining two lists into one big list

    Hi, I have two worksheets with two columns of text values in each (simplifying slightly): Worksheet 1 (7,000 rows): +-------+----------+ |Service|Component1| +-------+----------+ Service and Component1 may both contain blank values and duplicates in each column, although no duplicate...
  3. C

    Help to compare two lists to show a corrosponding value

    Hi, I have a list of towns and their post codes (post code list) in an excel spreadsheet. In a seperate spreadsheet I have a long list of addresses, I need to be able to look up each town in the post code list, and return the appropriate post code in the next column in my address list. Please...
  4. H

    Merging 2 sets of data together

    I have a list of controls along with various information about those controls as shown below: <TABLE style="WIDTH: 462pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=615 border=0 x:str><COLGROUP><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" span=2...
  5. J

    Combining two lists of data based on two conditions

    Hi All, First off, thanks in advance for any help on this. I've been reading/searching the forums for awhile now, but this is the first time I haven't been able to work out a solution to something from other posts, so here I am with post number 1. What I am trying to do is combine some...

Some videos you may like

This Week's Hot Topics