I forgot how to duplicate SCH 051
glad to help
regards
FSt1
"Steved" wrote:
Hello FSt1 from Steved
Thankyou
"FSt1" wrote:
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.
|