IF COUNTIF function not working correctly

[Helloitsme]

Hello all, unfortunately I can't get XL2BB program to work, so I'll try to describe my issue. It is likely an easy fix but I just can't seem to wrap my head around it.

Line	Value		Line	Value	Unique?
FIBER DSL	029860000		COAX I/E-KUNDE	028020000	X
TASTET AF:	076604000		FIBER DSL	029860000	X
M104895	076604000		TASTET AF:	076604000

Basically, I'm looking at the "Unique?" column. In this column I have used the following function:
=IF(COUNTIF(B:B;E2)>1;"";"X")

I want the column to fill in an X, when it detects a unique value that is not present in the left table. However, the "Fiber DSL" value is clearly visible in the left table, and I don't understand why an X is returned for this one.

Any help is greatly appreciated!

 

[Helloitsme]

I can't really tell anything from that as I can't see where or if 76603700 is in column B. Can you make up a small sample sheet where that circumstance occurs, perhaps by copying the worksheet and deleting most of the rows but keeping the problem, and posting all of it with XL2BB?

I figured it out, seems just my assumptions were wrong, everything is as it should be except my Excel search function seems to be acting up, hence my assumptions... Sorry for the trouble everyone but thanks for bearing over with me

Hope you all have a great day!

 

[Peter_SSs]

Glad you have it sorted. Thanks for letting us know.