Results 1 to 9 of 9

Thread: [RESOLVED] Counting pairs with their ID numbers code help

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    7

    Resolved [RESOLVED] Counting pairs with their ID numbers code help

    I have an excel file that counts pairs in a range of cells, their occurrences and list them in the result worksheet as Value1, Value2, Count. It is not useful for me this way.

    In addition to Count, I need the ID Numbers of rows that those pairs happen together.

    For example, if the Pair (A,B) has occurrence of 5, then the result should like this:
    Value1 (A), Value2 (B), Count (5) and ID Numbers (ID1, ID2, ID3, ID4, ID5).

    If the pair has occurrence of 7, then there should be ID Numbers.

    This code works normally without ID numbers, but in the example file, I added ID Numbers shown in Yellow, and sample data in Blue color. So the code needs to distinguish ID numbers and the data, and treat them as such. Any help would be appreciated.

    Here is the excel file link: https://1drv.ms/x/s!AoGkZUHlKui9gRWzqbBFZTJSIfiD
    Last edited by Matten; Aug 27th, 2017 at 09:56 AM.

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width