|
-
Aug 27th, 2017, 08:02 AM
#1
Thread Starter
New Member
[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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|