View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default count the amount of times a two letters appears in text string

Do you want to count if those 2 letters appear *in any order* ? For
example:

DFA

Should that be counted?

--
Biff
Microsoft Excel MVP


"Sam" wrote in message
...
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).