Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Extract 1st entry if more than 1 entry

    A strange extraction.
    I have a text column of part numbers.
    Many are unique and many appear more than 1 time.
    If the part number appears more than 1 time, I want that part number in another column.

    If the part number appears once, I ignore it.

    Only want those that appear more than 1 time and just want the first one.

    Thanks in advance.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Will the attached do what is needed?


    PS: Sort by Part number.
    Attached Files Attached Files
    Last edited by tfspry; 2011-02-07 at 19:47. Reason: added a PS

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Thanks. That'll work with a filter and copy/paste.

  4. #4
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts
    That will work if the list is sorted, if the numbers are in random order then some duplicates will be missed as they are not in adjacent rows
    Paul Coyle
    Approach love and cooking with reckless abandon

Posting Permissions

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