I have an application that has a series of ranges based on nine rows
and nine columns each (81 cells), and the cells are either blank or
contain integers. I need to do two things with these ranges. I am
moderately experienced with Excel and have a beginners knowledge of
Visual Basic.

1. Identify which if any of the nine rows have two and only two numbers
(not the same values), and that the two number pairs are identical. It
does not matter which cells in the rows contain the identical number
pairs, only that there are two rows with the same two numbers, and that
the value of these two numbers are known. Call them Pairs.

For example:

A B C D E F G H I

Row1 2 3 6 9
Row2 1 2 3 6 9
Row3
Row4 2 4
Row5 2 4
Row6 1 5
Row7 2 5 9
Row8
Row9 1 4 3 5 6 9

Row 4 and 5 have two numbers and the pairs are identical (2 and 4)


2. Identify which rows have more than two numbers and contain the
either of the pair values (2 and/or 4), and then delete the duplicate
numbers from the rows.

For example, delete the number 2 from Row2 ColC; delete the number 2
from Row7 ColA; delete the number 4 from Row9 ColC.

If anyone knows how to do this, I would be very grateful.

Carl