Results 1 to 3 of 3

Extract Duplicates Only

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-13-2010
    Location
    England
    MS-Off Ver
    Office 2016 365
    Posts
    211

    Extract Duplicates Only

    Hi,

    I hope someone can help, my excel knowledge isn't the most advanced and i'm sure this can't be too hard but am having a mental block.

    I have a table of items and each item has an individual reference number.

    I also have a list of reference numbers that i need to extract from that table.

    So as a very limited example my table might show

    Ref Item
    1 A
    2 B
    3 C
    4 D

    Then my list, in one column, is:

    Ref
    2
    3

    How do i cross reference the list against the table to extract:

    Ref Item
    2 B
    3 C

    Thanks in advance for any help!

    Jamie
    Last edited by JungleJme; 03-23-2011 at 12:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1