| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
returning blank cell in criteria o
Currently I am struckling with advanced filtering. In my criteria range
one cell contains an IF formula and the false condition it returns an empty cell "". Problem is now that advanced filter does not treat this as a true blank cell; it now only matches with strings. So if I have figure in this column of my database, it is not selected. I would like to return a true blank from my IF formula, so that everything is matched both strings and figures. Is this possible? Bye Joop |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
| Using IF when more than one cell contains criteria | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
