advanced filter - blanks

  • Thread starter Thread starter Mortir
  • Start date Start date
M

Mortir

id like to filter out the rows that have blanks in a certain column.
what condition do i give for criteria range?
 
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
 

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

Advanced Filter return blank 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Advanced Filter for multiple criteria, including blank cells 3
Help needed 0
VBA to Filter on variable column 5
Sorting Cells 8
Macro - How to not copy blank criteria? 1
Arrange to present in continuous format 4

Back
Top