Results 1 to 4 of 4

Matching pairs based on criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2019
    Posts
    758

    Matching pairs based on criteria

    Hi all,

    On the attached spreadsheet is 28 rows of data, across columns A-M (with F to I hidden)

    The data shown are pairs, based on their location and the times. The cell in column M is highlighted when there is a location and time match.

    At times I can work with 000's of rows of data and then I need to number the pairs in column D, as shown.

    A pair would be worked out based on column M being highlighted and the times in column C for the rows are within 10 minutes of a different coloured call (as shown by column A).

    I have started numbering the instances to show an example, but for 20,000 rows where there could be 9,000 instances it is hard to do manually.

    Any ideas how to automate the pairing?
    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. [SOLVED] Retain set of 4rows (pairs) based on multilple criteria in several columns
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-08-2016, 06:19 AM
  2. Matching Pairs
    By junada0 in forum Excel General
    Replies: 2
    Last Post: 02-11-2015, 05:46 PM
  3. aligning cells based on matching data in column pairs
    By freshfor88 in forum Excel General
    Replies: 2
    Last Post: 08-13-2014, 01:32 PM
  4. Matching Pairs
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2013, 04:20 PM
  5. [SOLVED] Count Unique Pairs of Excel Entries Based on Criteria
    By DonFord81 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2013, 01:12 PM
  6. [SOLVED] finding matching pairs
    By dave wagner in forum Excel General
    Replies: 2
    Last Post: 07-12-2011, 02:28 AM
  7. Replies: 10
    Last Post: 01-05-2011, 03:26 AM

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