Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering with keyword
We have columns with 50+ items that are unique. Filtering from using a
pulldown isn't desired. We need a keyword search. Is this possible? Similar to some sites that reduce results depending upon the keyword entered. example- Keyword: [ Carpet ] Carpet and Tile Carpet and VCT Wall mount Carpet Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering with keyword
We have columns with 50+ items that are unique. Filtering from using a
pulldown isn't desired. We need a keyword search. Is this possible? Similar to some sites that reduce results depending upon the keyword entered. example- Keyword: [ Carpet ] Carpet and Tile Carpet and VCT Wall mount Carpet Here's one way using Excel 2003. If the data is in columns B onward, with the item names in column B, and with row 1 as a title row, put this in A2 =ISNUMBER(SEARCH(A$1,B2)) and copy down as far as needed. Then select column A and use Data Filter AutoFilter The search term is typed into A1. Choosing TRUE in the A1 pull-down list filters the data. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering with keyword
That works great once. Am I don't something wrong? When I change the search
word, the autofilter doesn't update the column. Do I have to kep selecting the filter to update or can I get it to update the display when I change the keyword? "MyVeryOwnSelf" wrote: We have columns with 50+ items that are unique. Filtering from using a pulldown isn't desired. We need a keyword search. Is this possible? Similar to some sites that reduce results depending upon the keyword entered. example- Keyword: [ Carpet ] Carpet and Tile Carpet and VCT Wall mount Carpet Here's one way using Excel 2003. If the data is in columns B onward, with the item names in column B, and with row 1 as a title row, put this in A2 =ISNUMBER(SEARCH(A$1,B2)) and copy down as far as needed. Then select column A and use Data Filter AutoFilter The search term is typed into A1. Choosing TRUE in the A1 pull-down list filters the data. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering with keyword
Custom Filter on "contains"
Gord Dibben MS Excel MVP On Tue, 1 Sep 2009 15:55:01 -0700, c_robertson wrote: We have columns with 50+ items that are unique. Filtering from using a pulldown isn't desired. We need a keyword search. Is this possible? Similar to some sites that reduce results depending upon the keyword entered. example- Keyword: [ Carpet ] Carpet and Tile Carpet and VCT Wall mount Carpet Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
most popular keyword | Excel Worksheet Functions | |||
keyword search | Excel Discussion (Misc queries) | |||
Sort rows by keyword | Excel Worksheet Functions | |||
Sharing with Keyword | Excel Discussion (Misc queries) | |||
search by keyword | Excel Discussion (Misc queries) |