compare lists to highlight any changes in different list

  • Thread starter Thread starter crew3407
  • Start date Start date
C

crew3407

I am trying to figure out how to compare 2 lists that are not the sam
length and if the info appears in both lists, then it will extract th
corresponding values 2 columns next to that row in each list.

A B C D
1 go 2 bo
3 no 1 lo
6 to 8 up
2 bo 9 yo
0 ro
If we take the above as an example, you have column A and column C tha
you are comparing to see if the same info is in each column. If the
are the same, it checks to see if the info to the right of column A an
D are the same. (Ex. Col A and C both have the value 1, so then inf
next to Col A is go and info next to Col C is lo)

If the information in Col B and D are the same then nothing happen
(When col A and C = 2, then info next to them both = bo), but in th
case where the info is different as explained in first example, yo
want to highlight both rows of Column A and C.

Hopefully this is clear enough, and thanks for helping
 
Hi
try the following
- select column A
- goto 'Format - Conditional Format' and enter the following formula:
=SUMPRODUCT(--($C$1:$C$100=A1),--($D$1:$D$100=B1))=0
- choose a format

for column C enter the formula
=SUMPRODUCT(--($A$1:$A$100=C1),--($B$1:$B$100=D1))=0
 
Thank you very much! It worked beautifully. Now, I was wondering mayb
one other thing. Is it possible to not highlight, but extract th
information in those columns onto a different worksheet so I'd just b
able to print out the differences in a separated list? Thank you
 
Back
Top