Finding words

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

laurag - 14 Dec 2005 10:42 GMT

Hi.

I'm looking for a fonction or a macro to know if, in a reaserch, the
excel found or if he didn't find what a asked (I use function find at
text category to find words).

Exemple:
If he found at least 1 element, he returns 1.
If he found nothing, he returns 0.

Can you help me?

thanks

Signature

laurag

Reply to this Message

Dave Peterson - 14 Dec 2005 15:23 GMT

Maybe you can use =countif()

If you're looking for "research" anywhere in a1:A10, you could use:

=if(countif(a1:a10,"research")>0,1,0)
if "research" could be part of a longer string within any of those cells:
=if(countif(a1:a10,"*"&"research"&"*")>0,1,0)

> Hi.
>
[quoted text clipped - 15 lines]
> laurag's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29625
> View this thread: http://www.excelforum.com/showthread.php?threadid=493325

Signature

Dave Peterson

Reply to this Message

Bernie Deitrick - 14 Dec 2005 15:29 GMT

Laura,

=COUNTIF(A:A, "Laura")
to count cells that are exactly Laura in column A, or
=COUNTIF(A:A, "*Laura*")
to count cells that contain Laura in column A.

HTH,
Bernie
MS Excel MVP

> Hi.
>
[quoted text clipped - 9 lines]
>
> thanks

Reply to this Message