Dear all,

I have face a problem stated below:

A B C D
CN1 555555 CN1 444666
CN2 777888 CN3 888999
CNP1000 456456 CNP1001 123456
G1001 1234567 G1003 8888888
G1002 1234567 G1004 4564564
G1003 9999999 G1005 1222222
G1004 4564564 G1006 2525252
ZJ8000 894894 ZJ8000 894897
ZJ8500 123456 ZJ8501 123457

I will be comparing the 4 columns at the same time
Will it be possible to indicate in column E (DIFF!!!) if there is a different between Col B and Col D? And indicate in column F (BLANK!!!) when either one of the Col A/ B or Col C/D is not present ( CN2 & CN3 )and at the same time insert an empty cell ? Here are the lists staed below:


A..............B............. C..............D............. E............... F
CN1..........555555..... CN1......... 444666......DIFF!!!
CN2..........777888....._______....______.......................BLANK!!!
___...........______.....CN3..........888999......................BLANK!!!
CNP1000 456456.....____........._______.....................BLANK!!!
_______... _____.......CNP1001...123456.....................BLANK!!!
G1001.......1234567..._______...._______.....................BLANK!!!
G1002.......1234567..._______...._______.....................BLANK!!!
G1003.......9999999...G1003.......8888888.....DIFF!!!
G1004.......4564564...G1004.......4564564
G1005.......1222222..._______...._______.....................BLANK!!!
G1006 ......2525252.._______....._______.....................BLANK!!!
ZJ8000.......8948947...ZJ8000......8948977.....DIFF!!!
ZJ8500.......1234561...ZJ8501......1234571.....DIFF!!!

..... ( You can ignore the dots they are jus to indicate spaces in the excel
___ ( the underlines indicate the inserted blank cell )

Hope to hear from your soonest reply.
Warmest regards
Balfear