Please help! Displaying only rows with empty cells in a numeric field using Advanced Filter. Thanks

Folks,

I am learning how to use the Advanced Filter (Menus: Data, Filter, Advanced Filter). I can’t use Autofilter because in some cases I have to look for records that have to meet more than 2 conditions in the same field.

Some of the fields in the list that I am trying to filter have only numeric values. One of the conditions I am trying to define would allow me to filter the list exposing those rows in a numeric field that are blank (empty cells containing no data). I have tried using the following wildcard and formula combinations…
* , =C11="" and g
… in the criteria range (to filter out any cells that have something in it) but * only works on alphanumeric fields (not the purely numeric ones). The rest hide everything, including the empty cell I want to show.

Please, let me know how to filter my list using the Advanced Filter such that (in combination with my other conditions) I can expose only those rows having empty cells in my numeric field.

Thanks in advance to those who contribute.

JOCA

Use simply
not *

You could also set up a criteria with the first row empty and the 2nd row
being =LEN(C11)=0.

Bob Umlas
Excel MVP

"JOCA" wrote in message
...
Folks,

I am learning how to use the Advanced Filter (Menus: Data, Filter,
Advanced Filter). I can't use Autofilter because in some cases I have to
look for records that have to meet more than 2 conditions in the same field.

Some of the fields in the list that I am trying to filter have only
numeric values. One of the conditions I am trying to define would allow me
to filter the list exposing those rows in a numeric field that are blank
(empty cells containing no data). I have tried using the following wildcard
and formula combinations.
* , =C11="" and g
. in the criteria range (to filter out any cells that have something in
it) but * only works on alphanumeric fields (not the purely numeric ones).
The rest hide everything, including the empty cell I want to show.

Please, let me know how to filter my list using the Advanced Filter such
that (in combination with my other conditions) I can expose only those rows
having empty cells in my numeric field.

Thanks in advance to those who contribute.

JOCA