count Re-occurrences

Originally Posted by stevekirk

bryan,

i have attached a file with all the furmulars in that you have given me before

please see why it did not for work for me and adjust please

steve

A quick look (will be back in 2 days) suggests


AL1
dis = beam saw <<< you cannot search on this
AL2
=(LEN($AI2)-LEN(SUBSTITUTE($AI2,AL$1,"")))/LEN(AL$1)+((LEN($AJ2)-LEN(SUBSTITUTE($AJ2,AL$1,"")))/LEN(AL$1))
should be:
=(LEN(AI2)-LEN(SUBSTITUTE(AI2,"dis","")))/3+((LEN(AI2)-LEN(SUBSTITUTE(AI2,"saw","")))/3)

AM1
edge <<<< if 'edge' is 'egbd'
AM2
=(LEN($AI2)-LEN(SUBSTITUTE($AI2,AM$1,"")))/LEN(AM$1)+((LEN($AJ2)-LEN(SUBSTITUTE($AJ2,AM$1,"")))/LEN(AM$1))
should be:
=(LEN(AI2)-LEN(SUBSTITUTE(AI2,"egbd","")))/4

AN1
biesse
AN2
=(LEN(AI2)-LEN(SUBSTITUTE(AI2,AN$1,"")))/LEN(AN$1)

AO1
alt
AO2
=(LEN(AI2)-LEN(SUBSTITUTE(AI2,AO$1,"")))/LEN(AO$1)

AP1 ............ I presume you want to count 'bi'
bi
AP2
=(LEN(SUBSTITUTE(AI2,"biesse",""))-LEN(SUBSTITUTE(SUBSTITUTE(AI2,"biesse",""),"bi","")))/2

E2
_________________2L/2S
use
2L/2S
and align to right for your display.

AI2 is 30 always enough?
suggest 50
(I blew 30 in testing)

cheers
---