Need a function (or other way) to ...

[pmarques]

Need a function (or other way) to ...
compara 2 columms (A, B), with numbers; and return (to a third columm)
the values of the B that *are not * in A.

ThankS

 

[JE McGimpsey]

Take a look at

http://cpearson.com/excel/duplicat.htm#InOneNotOther

 

[pmarques]

Take a look at

http://cpearson.com/excel/duplicat.htm#InOneNotOther



I try to follow this steps, but i'm doing something rong!!!!
If someone help me the example file is in:

http://rapidshare.de/files/2993019/ex1.xls.html

(i wont to find (to E) the values of C tht are not in B)

 

[pmarques]

http://rapidshare.de/files/2993019/ex1.xls.html

or in attachement


+-------------------------------------------------------------------+
|Filename: ex1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3592 |
+-------------------------------------------------------------------+

 

[pmarques]

I've resolved the problem
it seems that in excel 97 intead of "," it is ";" in the formula
UAU!!!!!!!!

 

[Bob Phillips]

That is not Excel97, but Excel language versions. Some continental versions
use a ; separator, whilst most use the ,.