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

[Guest]

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

JOC

 

[Bob Umlas]

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

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

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.