ISBLANK

K

keyt

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

ie: Criteria

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

Thanks.
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Error? 3
Problem with Filter in Mail Merge 0
IF Function -- Return Null Value Help 2
Function returning unexpected value 7
IF ISBLANK Function 5
Testing a cell value for a specific weekday. 4
if(and(isblank( formula help 2
Dissect IF Statement 2

Top