| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN
I have a column of names and a corrosponding column containing their contact
numbers. I want to enter a paet of that name and i want to have all the names containing that part. but i cant find how to do this. please help. thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN
You could do that w/the autofilter (Data/Filter/Autofilter). Click on the
arrow that appears in the name column, select custom, then contains, and enter the name or partial name in the text box on the right side of the form. "arun_bhilai" wrote: I have a column of names and a corrosponding column containing their contact numbers. I want to enter a paet of that name and i want to have all the names containing that part. but i cant find how to do this. please help. thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for a value in one column and find another value from anoth | Excel Discussion (Misc queries) | |||
| Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
| Problem with search and replace data,thanks for you help in advance. | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Hybrid Mode
