ExcelBanter - advanced filter looking for blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - advanced filter looking for blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/139728-advanced-filter-looking-blank-cells.html)

pete the greek

advanced filter looking for blank cells

hi

i wonder if anyone knows the criteria to use in advanced filter to show
blank cell is a column. i have tried

null
isblank
="null"
="isblank"

Lori

advanced filter looking for blank cells

Try using just an equal sign: =.

On 20 Apr, 13:46, pete the greek
wrote:
hi

i wonder if anyone knows the criteria to use in advanced filter to show
blank cell is a column. i have tried

null
isblank
="null"
="isblank"

All times are GMT +1. The time now is 10:45 PM.