I had run it and it had matched one combination in column C with 5 combination in column G but it colored them red but only cause it match the first 3 numbers of the combination. it needs to be eact match of to be a duplicate. if its 1-1-1-2-3 then it should only be colored red 1-1-1-2-3 not 1-1-1-3-3. let me know if this helps.
The columns of data are different lengths.
Thank you
Reply With Quote