Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok, I'm embarrased by how dumb this question is... my customer has a
spreadsheet where they use "?" in a column, and I need to be able to quickly filter (not sort) their worksheet to pull just the rows that have a "?" in one of two target columns. I figured I could just do two auotfilters and work from the results (e.g. that may leave me with some duplicates when I combine the two results)- but the problem is that the custom autofilter considers ? to be a single wildcard character. I also tried "?" (in quotes) but that doesn't return any results at all, because the ? in each cell isn't surrounded by quotes (same for '?'). Is it possible to use custom autofilter (contains = something) to determine if a cell contains a questionmark? Thanks! Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Custom colors for cell shading in Excel | Excel Discussion (Misc queries) | |||
Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
How can I find strings of wildcards in Excel? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |