Filtering Table of results

[Chewyhairball]

Hi Guys

I have a large table of results i would like to be able to filter according to keywords typed into C2 looking at all of the descriptions in column C

for example I might be looking for all rows with the word 'MUD'. I would start typing 'mud' into cell C2 and as I type the cells automatically start filtering all the rows with the word 'MUD' somewhere in the text. If this is possible is it then possible to use multiple words to filter even further?

The sheet is frozen at row 4 so i can scroll through results.

as always thank you for looking at this for me.

Cheers

Rory

 

[Krayna]

Hi,
Have you tried the SEARCH function?

SEARCH Function

The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of find_text inside within_text as a number. SEARCH supports wildcards, and is not case-sensitive.

exceljet.net

 

[Chewyhairball]

Hi,
Have you tried the SEARCH function?

SEARCH Function

The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of find_text inside within_text as a number. SEARCH supports wildcards, and is not case-sensitive.

exceljet.net

I have looked at it but cant see how i cant get it to filter the rows by typing text into a search box?