Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with filters needed please
Can anyone tell me if it's possible to filter a list (one column) by Excel finding a particular word contained in a cell? eg: if each entry on my list was a sentence from a book, could I ask Excel to find only cells with the word "the" and show me only those lines? If this makes sense to anybody, I would appreciate any help you could give. Thanks, Debra -- Debra Hills ------------------------------------------------------------------------ Debra Hills's Profile: http://www.excelforum.com/member.php...o&userid=23540 View this thread: http://www.excelforum.com/showthread...hreadid=394036 |
#2
|
|||
|
|||
Select a cell in the list, and choose DataFilterAutoFilter
From the dropdown arrow in the column heading, select Custom From the first dropdown box, select Contains In the next box, type the word you want Click OK Debra Hills wrote: Can anyone tell me if it's possible to filter a list (one column) by Excel finding a particular word contained in a cell? eg: if each entry on my list was a sentence from a book, could I ask Excel to find only cells with the word "the" and show me only those lines? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
That is exactly what I was looking for. Thanks! :) -- Debra Hills ------------------------------------------------------------------------ Debra Hills's Profile: http://www.excelforum.com/member.php...o&userid=23540 View this thread: http://www.excelforum.com/showthread...hreadid=394036 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to aviod reset of Pivot filters when reconnecting to database? | Excel Discussion (Misc queries) | |||
Filters freezing program | Excel Discussion (Misc queries) | |||
Custom percent format needed | Excel Worksheet Functions | |||
How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
how do i see more than first 1000 unique entries filters dropdow.. | Setting up and Configuration of Excel |