Search field (please help)

[DeWaal Le Grange]

Hi excel experts

i need some help with something.

I have got all kinds of diferent names in B5:B300, i need a search field that will display all the cells containing the value or word i type in the search field.

for example. if a type "mica" it must bring up everything that consists of this word.

i need this because it takes time to search for sertain names or numbers.

If this is possible, please help me out.

Thank You

DeWaal

 

[Gerald Higgins]

Two easy options are
Edit, Find
and
Data, Filter, then Custom, contains.