LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default Blanks and Advanced Filters

Using <* works fine in an Advanced Filter when the field searched is TEXT,
but it does not work on numbers or dates. What's a good way of writing an
Advanced Filter that looks for blanks in a column with dates or numbers?

Examples:
Data range is like this:

TEXT NUMBER DATE
A 1 8/21/06
B 8/20/06
3 8/19/06
D 4

If Advanced Filter is TEXT <* then you get that third row -- the one with
the blank. BUT, if the Advanced Filter is NUMBER <* you get all records.
Same is true for the DATE column.
 
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
Advanced Filter (Criteria + Blanks) SamuelT Excel Discussion (Misc queries) 4 July 5th 06 05:03 PM
Advanced filtering on text and blanks dtencza Excel Discussion (Misc queries) 4 March 14th 06 01:07 AM


All times are GMT +1. The time now is 02:42 AM.

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

About Us

"It's about Microsoft Excel"