Columns

[tonyna22]

I have 2 columns with numbers in them...I want to check each column against the other to see which numbers are not in both columns..Is there a way to do this...?

 

[Jonmo1]

Sure, you can use match or countif..

Try this, assuming Columns A and B

In C1 put

=ISNUMBER(MATCH(B1,A:A,0))

And fill down to the end of column B

True means the number in column B also exists in Column A

 

[ka_123!]

if this is text...

B C
934 433 =EXACT(B13,$C$13:$C$25)
694 224
701 818
391 116
950 979
923 923
156 198
342 288
189 498
326 284
586 119
788 218
214 926