You would need 2 help columns, in one use

=IF(ISERROR(MATCH(A2,B:B,0)),A2,"")

copy down

in the other use

=IF(ISERROR(MATCH(B2,A:A)),B2,"")

will return 7 in the first and 1 in the second

Regards,

Peo Sjoblom



"akmccarthy" wrote:

I need to get the unique values between 2 columns. For example, if A has
2,3,4,5 & 7 and B has 1,2,3,4,and 5, I need something to tell me that B
doesn't have 7. I expect to run through it again so that I see that A doesn't
have 1. I do not wish to enter in the data to search for, but rather have a
column comparison and kickout the differences (similar to a diff command on
Unix for those that know it).

Any help would be appreciated. The advanced filter doesn't do what I need
as it would give me all values.
Thanks,
Kelly