ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN (https://www.excelbanter.com/excel-worksheet-functions/116508-approximate-search-any-entry-column.html)

arun_bhilai

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.


JMB

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.



All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com