Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Vancouver, Washington, USA
    Thanked 0 Times in 0 Posts

    New List from Existing List (Excel 2003)

    Okay, I'm stumped.

    I have an existing list of names, OS identification, and much other data. This list is the result of an import of delimted text file from an external source. No way to change how it gets into the text file.

    I am focused on the name and OS identification. Names and OS identification are duplicated in this list (because of the additional data in the list). We need to get out of this list a new list that only returns the names and OS identification with no duplications.

    See the attached sample workbook for an example. The desired list was created manually by visual inspection of the original list.

    I'd like to do this with formula(s) but am open to macro as well.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: New List from Existing List (Excel 2003)

    Here is a solution without formulas or macros:

    - Delete the first row in your sample worksheet so that the column headers are in A1:B1.
    - Copy the column headers A1:B1 to another location, e.g. to D1:E1.
    - Click anywhere in the original table.
    - Select Data | Filter | Advanced Filter..
    - Click "Copy to another location".
    - Click in the "Copy to" box.
    - Select D1:E1.
    - Tick the "Unique records only" check box.
    - Click OK.
    - Sort the new table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts