Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Extract list of data

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Wilmington North Carolina USA
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a large file with part numbers and product codes in it.
    I want to make a list of each unique product code and write it to a separate place, either a column on the same worksheet or another worksheet in the same file.
    The file is sorted in product code order, it is just too big to do manually.

    Can anyone help?

    Thanks

    Steve Morgan

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,033
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-26 12:58, srmorgan wrote:
    I have a large file with part numbers and product codes in it.
    I want to make a list of each unique product code and write it to a separate place, either a column on the same worksheet or another worksheet in the same file.
    The file is sorted in product code order, it is just too big to do manually.

    Can anyone help?

    Thanks

    Steve Morgan
    Use Advanced Filter where you check "Unique records only".

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Wilmington North Carolina USA
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And then I copy it to another cell or column, I take it. Is that right?


  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Wilmington North Carolina USA
    Posts
    161
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Worked great!

    Thanks

    Steve`

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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