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.
 
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
 
got it. criteria for blanks is "" under the column name with blanks
 
You must log in or register to reply here.

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
Advanced Filter Question 14

Back
Top