On Wed, 28 Sep 2005 13:19:19 +0200, Jerome MEYNENT wrote: >In cell H100, paste this formula : =SI(ESTERREUR(CHERCHE(H100;$C$3));0;1) >(has to be convert in local language something like >IF(ISERROR(LOOK(H100;$C$3));0;1) >Then copy down this formula from H100 TO H110 >In H111, sum those cells : SOMME(H100:H110) or SUM(H100:H110) >if the result of H111 is grater than 0 then there is at least 1 match. > >Objet : [users] What would be a formula for this?
>I have a list of 'phrases' in cells h100:h110. [snip] >ACH DB >Merch Fees >BOFA MS >Monthly Maintenance Fee > >I have a 'sentence' in cell C3 that may contain one of these phrases. > >I want to write a formula that will compare the list of phrases to the >words in C3 and show if there is a match. Interesting way to do this. I think I should use I100 - I110 though ;-) -- Greg Agent 1.93/32.576 Opera8 OOo2(19125) news.readfreenews.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: geardocATgeardoc36DOThostingisfreeDOTcom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
