Thread: I forgot how to duplicate SCH 051
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
  
Posts: 519
Default 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.
Reply With QuoteReply With Quote