how to find unpaired values at comparison of two columns

[Oleg]

How to find unpaired values at comparision of two data columns

Example in attachmen

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52561

 

[Frank Kabel]

Hi
try the following:
- select cells A1:A18
- goto Format - Conditional format
- enter the following formula
=COUNTIF($B$1:$B$30,A1)=0
- choose a format

After this select B1:B18 and in the conditional format
dialog enter the formula
=COUNTIF($A$1:$A$30,B1)=0

 

[Oleg]

WHEN I ENTER THE FORMULA THERE IS AN ERROR MESSAGE

!!!ERROR MESSAGE IN ATTACHMEN

Attachment filename: error.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52565

 

[Frank Kabel]

Hi
do you also get an error if you enter this formula in an
empty cell?
If yes, what field separator do you use (depens on your
regional settings)

 

[DNF Karran]

Should be what your after....

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52578

 

[Oleg]

I have replaced separator on semicolon and now all ok !!!

Thanks for help