I forgot how to duplicate SCH 051
 

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.

I forgot how to duplicate SCH 051
 

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.

I forgot how to duplicate SCH 051
 

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.

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.