Two lists, need quick way to see the differences

[RET79]

hi,

I got two lists of policy numbers (unique).

I want to know which policies are in one list and not the other quickly etc. I would usually use Access, is there a quick way of doing it in excel without having to do much work? If your solution is not quicker than it would take to put the data into access and run a few queries there then it's not really what I'm looking for sorry!

Thanks.

 

[Andrew Poulsom]

Let's say the lists are in ranges A1:A10 and B1:B10. For a quick visual check, select all the cells in A1:A10 and choose Format|Conditional Formatting from the menu. Condition 1 Formula is:

=ISNA(MATCH(A1,$B$1:$B$10,0))

click Format, choose a Pattern color and click OK twice.

You can repeat the process for B1:B10 if you want, but change the formula to:

=ISNA(MATCH(B1,$A$1:$A$10,0))

 

[Aladin Akyurek]

See also...

http://www.mrexcel.com/board2/viewtopic.php?t=50947

&

http://www.mrexcel.com/board2/viewtopic.php?p=208065&highlight=mconcat#208065

 

[RET79]

Thanks Aladdin, that's a real *******!