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