Thread: how do I count the number of times a word is repeated in a range?
View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default
Adapted from Dave Peterson's fine earlier post...........

=SUMPRODUCT(LEN(A1:C101)-LEN(SUBSTITUTE(UPPER(A1:C101),UPPER(D1),"")))/LEN(D
1)

Vaya con Dios,
Chuck, CABGx3


"sol" wrote in message
...



Reply With QuoteReply With Quote