advanced filter - blanks
 

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

advanced filter - blanks
 

Hi

Use an AutoFilter, and select NonBlank as criteria.

Hopes this helps.

---
Per

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

advanced filter - blanks
 

On 8 feb., 10:44, "Per Jessen" wrote:
Hi

Use an AutoFilter, and select NonBlank as criteria.

Hopes this helps.

---
Per

"Mortir" skrev i ...

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



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

advanced filter - blanks
 

got it. criteria for blanks is "" under the column name with blanks