APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN

A

arun_bhilai

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.
 
J

JMB

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.
 
Top