Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does Not Equal
I've encountered this problem both with Excel 2003 and 2007. Attempting the
same thing in Access works fine. I'd sure appreciate it if someone could tell me why it doesn't work in Excel and does in Access. Specifically, I have a spreadsheet where data in all but the date column is formatted as text. That means "John", W3B29AWV", and "0502" are all text fields. When I do either an AutoFilter or an Advanced Filter, if I look for a specific thing, the proper results are returned. Using a "does not equal" in AutoFilter, or < in Advanced Filter works most of the time. However, if I select a "does not equal" out of the AutoFilter, or use < as criteria in the Advanced filter, for the field that contains all numbers (0502 in this example), the criteria is totally ignored. What is it about a "text" field that is entirely numbers that the programs don't like. As I've said, I've generated a query in Access and successfully had it work, but it doesn't in Excel. Any info you could provide, either as to why it doesn't work, or how to make it work, would be appreciated. Thanks in advance for any and all assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
Using = (equal) | Excel Discussion (Misc queries) | |||
CountIF(A9:A20, B9 not equal B10, B10 not equal B11, etc.) | Excel Worksheet Functions | |||
Value of Less Than Zero to Equal Zero | Excel Discussion (Misc queries) | |||
Getting 0 to equal 1 | Excel Worksheet Functions |