Thread: use of wildcards
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
italiavb italiavb is offline
external usenet poster
  
Posts: 19
Default use of wildcards
Does anyone know how to use wildcards properly in a formula. For example
(=SUMPRODUCT((A1:A4="6-*")*(C1:C4="ok")*(B1:B4="c-25")). Where "6-*" would
be anywhere the entry in cells A1:A4 begins with the number 6.


Reply With QuoteReply With Quote