Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find
I have a worksheet with 100s of names. The first & last names are on
separate cells (in the same row). I am trying to find JOHN DOE, how do I search for it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find
You can create a column with the two names joined, with a formula like:
=A1 & " " & B1 And then use the menu Edit - Find. You need to assure that you look for values, that setting can be found on the options section, in the "look in" drop down. Hope this helps, Miguel. "Roger" wrote: I have a worksheet with 100s of names. The first & last names are on separate cells (in the same row). I am trying to find JOHN DOE, how do I search for it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find
Maybe something like this:
For a list of names in A1:B1000 (Col_A holds firstnames, Col_B holds last names C1: (a name to match...eg John Doe) This formula returns TRUE if the name is found, or FALSE for no match: D1: =SUMPRODUCT((A1:A1000&" "&B1:B1000=C1)*ROW(A1:A1000))0 Or...you could use this ARRAY FORMULA*: D1: =ISNUMBER(MATCH(C1,A1:A1000&" "&B1:B1000,0)) *Note: For array formulas, hold down [Ctrl] and [Shift] when you press [Enter], instead of just pressing [Enter]. Does that help? *********** Regards, Ron XL2002, WinXP "Roger" wrote: I have a worksheet with 100s of names. The first & last names are on separate cells (in the same row). I am trying to find JOHN DOE, how do I search for it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |