Thread: count the amount of times a two letters appears in text string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default count the amount of times a two letters appears in text string
=SUMPRODUCT(--(ISNUMBER(SEARCH("A*D",A1:A5))))


"Sam" wrote:

please help!!

I have a column of different sequenced letters.eg
AD
AFD
AC
AFDE
ADEF

I want to count the amount of times that both "A" and "D" occur in the data
set (4).
Reply With QuoteReply With Quote