Results 1 to 3 of 3

Matching Pairs

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-16-2009
    Location
    Sheffield
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    118

    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

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