Hi guys! I am hoping someone has an answer for this, as I am stuck. I
have a spreadsheet with two columns. Each column contains a bunch of
codes. I need to be able to identify any code that appears in one
column, but not the other (doesn't matter which one).

So, if the code appears in column A but not B, I need to know about
it.
If the code appears in column B but not A, I need to know about it.

I know this can be done with a formula, but I am not sure what it is!
PLease help! Thanks.


--
dfeld71
------------------------------------------------------------------------
dfeld71's Profile: http://www.excelforum.com/member.php...o&userid=21452
View this thread: http://www.excelforum.com/showthread...hreadid=386934