D
Demitre
Hello,
I am trying to validate the data in 3 columns. The 2nd 2 should match
the first column.
Example 1st column: A
x2
y2
z3
x1
y1
z8
y8
example of 2: B
x1
x2
example of column 3: C
y1
y2
As you can see, column 2 and 3 matches up, and I want to validate that
column 2's x1 is found in column 1, and the Y below that row is the
same as the coresponding collumn 3. Collumn 1 isn't in any sort of
order, so you'll have to search for it.
Something like Match(A:A:B1) and when match check match(Ax-1:C1), If
not true, highlight the cell.
I am trying to validate the data in 3 columns. The 2nd 2 should match
the first column.
Example 1st column: A
x2
y2
z3
x1
y1
z8
y8
example of 2: B
x1
x2
example of column 3: C
y1
y2
As you can see, column 2 and 3 matches up, and I want to validate that
column 2's x1 is found in column 1, and the Y below that row is the
same as the coresponding collumn 3. Collumn 1 isn't in any sort of
order, so you'll have to search for it.
Something like Match(A:A:B1) and when match check match(Ax-1:C1), If
not true, highlight the cell.