# Thread: Find unique values between two columns Thanks:  1 Post #5327405 (1) Likes:  3 Post #5327405 (2)Post #5327411 (1)

1. ## Find unique values between two columns

Hi All

I am comparing two columns to find unique values. I have the below but I need help to stop blank cells returning a yes value.

=IF(ISNA(VLOOKUP(E3,\$B\$3:\$B\$7000,1,FALSE)),"Yes","NO")
I would also like to count the unique values but avoid an array formula. I have the below but not yet working:

=SUM(1/COUNTIF(\$E\$3:\$E\$7000, \$E\$3:\$E\$7000))+SUM(IF(COUNTIF(\$E\$3:\$E\$7000, \$B\$3:\$B\$7000)=0, 1/COUNTIF(\$B\$3:\$B\$7000, \$B\$3:\$B\$7000), 0))
Many thanks for any help

2. ## Re: Find unique values between two columns

I hope something like this helps you:

 B C D E F 2 DATA UNIQUE DATA UNIQUE 3 data3 no data3 no 4 data4 yes data5 no 5 data5 no data7 no 6 data6 yes data9 yes 7 data7 no data11 yes 8 data8 yes data13 yes

 Cell Formula C3 =IF(COUNTIF(\$B\$3:\$B\$8,B3)+COUNTIF(\$E\$3:\$E\$8,B3)=1,"yes","no") F3 =IF(COUNTIF(\$B\$3:\$B\$8,E3)+COUNTIF(\$E\$3:\$E\$8,E3)=1,"yes","no")

3. ## Re: Find unique values between two columns

@DanteAmor thank you very much! Just the overall count formula now to go