jwerth
01-12-2017, 09:36 AM
Hello,
I am attempting to do an index match in a case where I do not have an entirely unique identifier. I will use the Col. 1 and Col. 2 below to demonstrate my problem. In my example I am trying to find discrepancies between 2 columns. When I index match from column 2 to the column 1 there is a 3 in column 2 so both of the 3's in column 1 will show as matching. What I would like to have is that when there are fewer 3's in column 2 than in column 1 to have the 3's in column 1 highlighted so that I know that a discrepancy somewhere within the two values in column 1 exist between the second and first column.
18014
Thanks,
Justin
I am attempting to do an index match in a case where I do not have an entirely unique identifier. I will use the Col. 1 and Col. 2 below to demonstrate my problem. In my example I am trying to find discrepancies between 2 columns. When I index match from column 2 to the column 1 there is a 3 in column 2 so both of the 3's in column 1 will show as matching. What I would like to have is that when there are fewer 3's in column 2 than in column 1 to have the 3's in column 1 highlighted so that I know that a discrepancy somewhere within the two values in column 1 exist between the second and first column.
18014
Thanks,
Justin