 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2005finding 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 Use the COUNTIF() function. =COUNTIF(Names,"George") This will give you a count of the number of times George is there Cutter, I think your PC clock may be wrong (or the time zone is incorrectly set) ...  SignatureVasant > Use the COUNTIF() function. > > =COUNTIF(Names,"George") > > This will give you a count of the number of times George is there. 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 >Cutter, I think your PC clock may be wrong (or the time zone is incorrectly >set) ... 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?? >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. [quoted text clipped - 6 lines] >>Cutter, I think your PC clock may be wrong (or the time zone is incorrectly >>set) ... Hi, Sheila. You could try something like this: =if(left(a1,6)="george",True,False) ************ Anne Troy www.OfficeArticles.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 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 SignatureVasant > 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 Sorry, I just realized you wanted a formula. Try: =COUNTIF(Names,"George")>0 SignatureVasant > 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 Well....but... I got PART of it right!! Hee hee... ************ Anne Troy www.OfficeArticles.com > Sorry, I just realized you wanted a formula. Try: > [quoted text clipped - 5 lines] >> TIA >> sheila :-) > Well....but... I got PART of it right!! Hee hee... > ************ [quoted text clipped - 10 lines] >>> TIA >>> sheila |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.