| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I filter columns and rows for a certain word in Excel?
I want to set up a filter so if a row has a certain word in any column, it
shows up. Is this possible? If so, how do I do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I filter columns and rows for a certain word in Excel?
I would use another column and put a formula like:
=countif(a2:m2,"*" & "whateveryouwanthere" & "*")0 Then filter on True/falses. (And adjust that range to match your data.) Sebastian wrote: I want to set up a filter so if a row has a certain word in any column, it shows up. Is this possible? If so, how do I do it? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| Excel - columns into rows | Excel Discussion (Misc queries) | |||
| Excel - Columns into rows | New Users to Excel | |||
| Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Linear Mode
