Hello,

I have two huge tables that i need to compare and find out diferences beetween them.
Tables are randomly sorted so basicly i need full cross check.


Exemple:


Frst row from first table can be anywhere in second table. I only need to know is it there! If it's not, need to be marked or copied in third sheet..i dont really care.


Tables can be compared column G - DOC NUMBER.


So if anyone has an idea i would be grateful.

Win 7
Office 2013
http://i57.tinypic.com/adlv2w.jpg