advanced filter - blanks

M

Mortir

id like to filter out the rows that have blanks in a certain column.
what condition do i give for criteria range?
 
M

Mortir

Hi

Use an AutoFilter, and select NonBlank as criteria.

Hopes this helps.
Click to expand...

hi. tnx, but id like to do it with advanced filter> plus id like to
get the result of advanced filter so that Only the rows that have
blanks in a certain column show up
 
Top