I forgot how to duplicate SCH 051

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

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.
 
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
 
Back
Top