finding if name within range

[sheila]

If i have a range, lets name it "Names" and i want to find if the name
George is in that range, what formula should I use?

TIA
sheila

[Cutter]

Use the COUNTIF() function.

=COUNTIF(Names,"George")

This will give you a count of the number of times George is there.

[Anne Troy]

Hi, Sheila. You could try something like this:
=if(left(a1,6)="george",True,False)
************
Anne Troy
www.OfficeArticles.com

"sheila" <sheilaso_n_e@hotmail.com> wrote in message
news:8c2ci1p3rp9k27622fccmklptq0gtsulq7@4ax.com...
> If i have a range, lets name it "Names" and i want to find if the name
> George is in that range, what formula should I use?
>
> TIA
> sheila

[Vasant Nanavati]

I *think* Anne may have misread the question. Try this function:

Function IsGeorgeInThere() As Boolean
Dim c As Range
For Each c In Range("Names").Cells
If c = "George" Then
IsGeorgeInThere = True
Exit Function
End If
Next
End Function

--

Vasant





"sheila" <sheilaso_n_e@hotmail.com> wrote in message
news:8c2ci1p3rp9k27622fccmklptq0gtsulq7@4ax.com...
> If i have a range, lets name it "Names" and i want to find if the name
> George is in that range, what formula should I use?
>
> TIA
> sheila

[Vasant Nanavati]

Sorry, I just realized you wanted a formula. Try:

=COUNTIF(Names,"George")>0

--

Vasant




"sheila" <sheilaso_n_e@hotmail.com> wrote in message
news:8c2ci1p3rp9k27622fccmklptq0gtsulq7@4ax.com...
> If i have a range, lets name it "Names" and i want to find if the name
> George is in that range, what formula should I use?
>
> TIA
> sheila

[Anne Troy]

Well....but... I got PART of it right!! Hee hee...
************
Anne Troy
www.OfficeArticles.com

"Vasant Nanavati" <vasantn AT aol DOT com> wrote in message
news:OYSj$c$tFHA.3720@TK2MSFTNGP14.phx.gbl...
> Sorry, I just realized you wanted a formula. Try:
>
> =COUNTIF(Names,"George")>0
>
> --
>
> Vasant
>
>
>
>
> "sheila" <sheilaso_n_e@hotmail.com> wrote in message
> news:8c2ci1p3rp9k27622fccmklptq0gtsulq7@4ax.com...
>> If i have a range, lets name it "Names" and i want to find if the name
>> George is in that range, what formula should I use?
>>
>> TIA
>> sheila
>
>

[Vasant Nanavati]

:-)


"Anne Troy" <ng@officearticles.com> wrote in message
news:u129Zh$tFHA.2880@TK2MSFTNGP12.phx.gbl...
> Well....but... I got PART of it right!! Hee hee...
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Vasant Nanavati" <vasantn AT aol DOT com> wrote in message
> news:OYSj$c$tFHA.3720@TK2MSFTNGP14.phx.gbl...
>> Sorry, I just realized you wanted a formula. Try:
>>
>> =COUNTIF(Names,"George")>0
>>
>> --
>>
>> Vasant
>>
>>
>>
>>
>> "sheila" <sheilaso_n_e@hotmail.com> wrote in message
>> news:8c2ci1p3rp9k27622fccmklptq0gtsulq7@4ax.com...
>>> If i have a range, lets name it "Names" and i want to find if the name
>>> George is in that range, what formula should I use?
>>>
>>> TIA
>>> sheila
>>
>>
>
>

[Vasant Nanavati]

Cutter, I think your PC clock may be wrong (or the time zone is incorrectly
set) ...

--

Vasant


"Cutter" <Cutter.1v9taj_1126569940.9396@excelforum-nospam.com> wrote in
message news:Cutter.1v9taj_1126569940.9396@excelforum-nospam.com...
>
> Use the COUNTIF() function.
>
> =COUNTIF(Names,"George")
>
> This will give you a count of the number of times George is there.
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile:
> http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=466975
>

[sheila]

Kind of right, but if the name George does appear in the range, I want
that name (George) to appear in the cell that has the formula.

how do i do that?


TIA
sheila



On Mon, 12 Sep 2005 20:34:01 -0400, "Vasant Nanavati" <vasantn AT aol
DOT com> wrote:

>Cutter, I think your PC clock may be wrong (or the time zone is incorrectly
>set) ...

[sheila]

and i guess i should also add, IF the name George doesnt appear in the
range, then I would like something else searched and used (say
"Harry"),,does that make sense??



On Tue, 13 Sep 2005 15:22:48 +1200, sheila <sheilaso_n_e@hotmail.com>
wrote:

>Kind of right, but if the name George does appear in the range, I want
>that name (George) to appear in the cell that has the formula.
>
>how do i do that?
>
>
>TIA
>sheila
>
>
>
>On Mon, 12 Sep 2005 20:34:01 -0400, "Vasant Nanavati" <vasantn AT aol
>DOT com> wrote:
>
>>Cutter, I think your PC clock may be wrong (or the time zone is incorrectly
>>set) ...