Filtering Blank/Empty Cells

tanda · Feb 24th, 2002, 06:24 PM

Is there a way to filter for blank or empty cells. I have data to sort in which zero is reflected as a blank/empty cell. I need to filter all cells in the column for those with contents/values that are (for example) less than three. Since zero is blank/empty, this is a problem. I would like to set the filter for <3 or and then some criteria which indicates blank/empty cells.

Derek · Feb 24th, 2002, 06:33 PM

Hi
Try using the custom feature of the autofilter which gives you a whole range of options
Derek

tanda · Feb 24th, 2002, 06:45 PM

Yes, I knew that, but not what criteria to use. I have since realized that = returns blank cells.

Tom Urtis · Feb 24th, 2002, 06:54 PM

Tanda,

The criteria to use to filter for blank cells is an equal sign "=" (without the quotes).

To filter for non-blank cells, use the criteria ="<>" just as you see it here, with the equal sign and with the quotes.

Tom Urtis

gareth · Apr 24th, 2002, 12:32 AM

If you want to filter the blanks or non-blanks,I think you should go right down to the selection of filtering in the filter box.You will find it there.It should be last.

Apr 24th, 2002, 12:32 AM	#5
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	If you want to filter the blanks or non-blanks,I think you should go right down to the selection of filtering in the filter box.You will find it there.It should be last. __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 24th, 2002, 06:24 PM	#1
tanda New Member Join Date: Feb 2002 Posts: 13	Is there a way to filter for blank or empty cells. I have data to sort in which zero is reflected as a blank/empty cell. I need to filter all cells in the column for those with contents/values that are (for example) less than three. Since zero is blank/empty, this is a problem. I would like to set the filter for <3 or and then some criteria which indicates blank/empty cells.

Feb 24th, 2002, 06:33 PM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Try using the custom feature of the autofilter which gives you a whole range of options Derek

Feb 24th, 2002, 06:45 PM	#3
tanda New Member Join Date: Feb 2002 Posts: 13	Yes, I knew that, but not what criteria to use. I have since realized that = returns blank cells.

Feb 24th, 2002, 06:54 PM	#4
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,383	Tanda, The criteria to use to filter for blank cells is an equal sign "=" (without the quotes). To filter for non-blank cells, use the criteria ="<>" just as you see it here, with the equal sign and with the quotes. Tom Urtis