Need to find matching data in filtered columns

Probably missing something obvious here.

Code needs to filter Col C to show only entries with "2" value (which means there are two records with the same combination in Col B).

What I cannot see is how to then "find" each pair in Col B? Because if I don't know what row number will be the first filtered record, I won't be able to set the "Find" function to look for whatever is in Col B of that row, then cycle to the next visible row.

Having found the pair, the Code will then compare Col A. If both values match, the records go to Col H - J, and if they are different the records go to Col M, as shown on the attached.

Please Login or Register  to view this content.

All suggestions, pointers and solutions accepted gratefully, as ever

Ochimus

Maybe this will work for you

Please Login or Register  to view this content.