If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|