Hello from Steved

If I change the Data in Col C3 or Col H3 "dup" is not Displayed, is what I
require

If I change the Data in Col B3 or Col G3 "dup" Stays Displayed Why? please.

=IF(COUNT(B3,G3)<2,"",IF(C3=H3,"dup",""))

Logical_test COUNT(B3,G3)<2 = False
Value_if_True "" = ""
Value_if_False IF(C3=H3,"dup","") = "dup"
= "dup"

Thankyou.