ISBLANK

  • Thread starter Thread starter keyt
  • Start date Start date
K

keyt

What is the syntax required to include ISBLANK within the
criteria of an advanced filter?

ie: Criteria

Name Date
TOM =ISBLANK(???) ???

Thanks.
 
Assume your list is in A2:B200

(headers included)

in E1 put TOM and in F2 put

=B3=""

(B3 is the first cell after the header)


now apply the filter and in the criteria put

$E$1:$F$2

click OK
 
Back
Top