ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Advanced filtering how do you define a cell as blank (https://www.excelbanter.com/excel-discussion-misc-queries/120701-re-advanced-filtering-how-do-you-define-cell-blank.html)

TMC

Advanced filtering how do you define a cell as blank
 
Yes, thanks. I however need to use the advanced function for what I am doing.

"Teethless mama" wrote:

Have you tried using the Auto filter?

"TMC" wrote:

I have set up my criteria range using the advanced filtering function. I
want to set up a multiple column search of which on of the columns filtering
criteria is to filter all the blank cells.

I don't know how to specify blank cells as a search criteria



All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com