Thread: Find specific value in a string
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Find specific value in a string
Woops that should be

=IF(COUNTIF(B$2:B$16,"*11*")+COUNTIF(B$2:B$16,11) 0,"Yes","No")

HTH
Martin


Reply With QuoteReply With Quote