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