Home |
Search |
Today's Posts |
#1
|
|||
|
|||
finding if name within range
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Hi, Sheila. You could try something like this:
=if(left(a1,6)="george",True,False) ************ Anne Troy www.OfficeArticles.com "sheila" wrote in message ... 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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
#5
|
|||
|
|||
Sorry, I just realized you wanted a formula. Try:
=COUNTIF(Names,"George")0 -- Vasant "sheila" wrote in message ... 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 |
#6
|
|||
|
|||
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 ... Sorry, I just realized you wanted a formula. Try: =COUNTIF(Names,"George")0 -- Vasant "sheila" wrote in message ... 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 |
#7
|
|||
|
|||
:-)
"Anne Troy" wrote in message ... 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 ... Sorry, I just realized you wanted a formula. Try: =COUNTIF(Names,"George")0 -- Vasant "sheila" wrote in message ... 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 |
#8
|
|||
|
|||
Cutter, I think your PC clock may be wrong (or the time zone is incorrectly
set) ... -- Vasant "Cutter" wrote in message ... 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 |
#9
|
|||
|
|||
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) ... |
#10
|
|||
|
|||
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 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) ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding unnamed cells in a range | Excel Discussion (Misc queries) | |||
Finding LARGE value within range of lookup table | Excel Discussion (Misc queries) | |||
Finding dates within a date range | Excel Worksheet Functions | |||
Finding Dates in a date range | Excel Discussion (Misc queries) | |||
need help finding a Date range within long list | Excel Worksheet Functions |