Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I forgot my password, how do I open a sheet if I forgot the pass | Excel Worksheet Functions | |||
Forgot | Excel Worksheet Functions | |||
Forgot the Password | Excel Discussion (Misc queries) | |||
Forgot password | Excel Discussion (Misc queries) | |||
Help...Forgot my Password | New Users to Excel |