Thread: count the amount of times a two letters appears in text string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
  
Posts: 699
Default count the amount of times a two letters appears in text string
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