I have a table of data with one column of ID numbers and another column of contingency numbers. Some contingencies can be comprised of one ID number or multiple ID numbers (multiple contingencies). The contingencies that are only one ID number are simple to identify duplicates however I am attempting to create a code that identifies the groups that are the same.
My attempts to identify the multiple contingencies and provide the lowest of contingency numbers has had bugs all over. However what I do have is a dynamic array that contains some reference information: the first column is how many ID numbers within a contingency (currently ranging from 1 to 6), the second column is the amount of times that length occurs (i.e. 3 groups of 4), and finally the last column is the first cell that those groups start on.
Below is a screenshot of two separate arrays. The first one I mentioned above is in Column A:C and the second one containing the ID number, the number instances that the that contingency exists (same idea as column A), then I concatenated the ID number with the instances, and finally is the contingency number. As an example contingency 393 is the same length and contains identical elements as contingency 210. So what I want is for Range("H25:H28") to have 210's in those cells (which would be the 5th column of that data array).
I know this may be confusing
so feel free to ask me anything that may be clarifying.
Thank you in advance for your help.
AJ
My attempts to identify the multiple contingencies and provide the lowest of contingency numbers has had bugs all over. However what I do have is a dynamic array that contains some reference information: the first column is how many ID numbers within a contingency (currently ranging from 1 to 6), the second column is the amount of times that length occurs (i.e. 3 groups of 4), and finally the last column is the first cell that those groups start on.
Below is a screenshot of two separate arrays. The first one I mentioned above is in Column A:C and the second one containing the ID number, the number instances that the that contingency exists (same idea as column A), then I concatenated the ID number with the instances, and finally is the contingency number. As an example contingency 393 is the same length and contains identical elements as contingency 210. So what I want is for Range("H25:H28") to have 210's in those cells (which would be the 5th column of that data array).
I know this may be confusing
so feel free to ask me anything that may be clarifying.Thank you in advance for your help.
AJ
