hi
Because SCH 051 is text and the count functions is for numbers.
the count function in your fomula is trying to count numbers, it always find
0 numbers which is always less that 2 so it always displays "".
use the Counta function in your formula. it is for counting text.
=IF(COUNTA(F3,B3)2,"",IF(F3=B3, "dup",""))

i think it will work for you then.
regards
FSt1

"Steved" wrote:

Hello from Steved

With the formula below why is it not displaying "dup" for "SCH 051" "SCH
051" please.

=IF(COUNT(F3,B3)2,"",IF(F3=B3, "dup",""))

SCH 051 SCH 051

Thankyou.