+ Reply to Thread
Results 1 to 3 of 3

Matching Pairs

  1. #1
    Forum Contributor
    Join Date
    08-16-2009
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    109

    Matching Pairs

    Hi,

    Any help please I have a large list of data with duplicate pairs of identical data across 3 columns and would like some way to mark each pair with a unique reference index number as seen in the example enclosed.

    In the example rows 2 & 3 have identical data so would like to mark as pair #1
    In rows 4 & 5 again matching so pair #2
    In rows 6 & 8 again matching so pair #3
    etc

    Thanks in anticipation
    G
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Matching Pairs

    Put this formula in E2 and then fill down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    08-16-2009
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: Matching Pairs

    Many thanks,

    This works fine on the example file, but it seems to match pairs for just the Ser No in Col C,is it possible to edit to ensure col A&B and also C are matched also as occasionally the Ser no is repeated on my larger file, sorry for not explaining this.

    Thanks
    G

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Matching Pairs
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2013, 04:20 PM
  2. [SOLVED] finding matching pairs
    By dave wagner in forum Excel General
    Replies: 2
    Last Post: 07-12-2011, 02:28 AM
  3. Replies: 10
    Last Post: 01-05-2011, 03:26 AM
  4. Matching pairs of data
    By sjgeewhiz in forum Excel General
    Replies: 3
    Last Post: 12-31-2008, 02:31 PM
  5. Unique records of matching pairs
    By pmarques in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-25-2005, 12:23 PM

Tags for this Thread

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