C
CLR
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
=SUMPRODUCT(LEN(A1:C101)-LEN(SUBSTITUTE(UPPER(A1:C101),UPPER(D1),"")))/LEN(D
1)
Vaya con Dios,
Chuck, CABGx3