Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,718
Default Advanced filtering how do you define a cell as blank

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank cell is not blank Otto Moehrbach Excel Discussion (Misc queries) 7 November 19th 06 03:35 PM
Replace null string with blank cell gjcase Excel Discussion (Misc queries) 2 August 9th 05 02:13 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
blank cell turns to 0 LMB New Users to Excel 2 April 25th 05 03:57 PM
Look for change next blank cell in Range Nigel Bennett Excel Worksheet Functions 1 March 13th 05 09:45 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"