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
 

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 3
look up a value in one column to another colum 7
How do I move entire row from one excel sheet to another 3
need to write query in code, getting error 1
UDF/Formula to replace only specific 3
Creating a Lookup Table Using a Do...Until Loop 6
Creating a Lookup Table Using Do...Until Loop 2

Back
Top