I forgot how to duplicate SCH 051

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.
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract value from a text string 11
My Duplicate formula is not functioning as it should 4
look up a value in one column to another colum 7
UDF/Formula to replace only specific 3
Macro Question 8
giving me #Value! 4
Sorting with VBA (Tough) 0
Creating a Lookup Table Using a Do...Until Loop 6

Top