Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
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
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