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 : SOM
On Tue, 27 Sep 2005 12:20:35 -0700, David Chapman wrote:
>SEARCH allows regular expressions - including logical operators.
>
>To keep my example small, I have Dave in C2 and Greg in C3
>
>My sentence is C4
>
>=SEARCH(CONCATENATE(C2;"|";C3);C4) returns a non-error value if the sentence C4
>contains
SEARCH allows regular expressions - including logical operators.
To keep my example small, I have Dave in C2 and Greg in C3
My sentence is C4
=SEARCH(CONCATENATE(C2;"|";C3);C4) returns a non-error value if the sentence C4
contains Dave or Gerry
On 9/27/05, GregChi <[EMAIL PROTECTED]> wrote:
>
