View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Advanced Filter problem

No, the empty string won't affect the filter.
Did you test both the control date, and a date in a record?
Did you use an absolute reference to the control date in the criteria
formula?

R. Choate wrote:
It tested as a legitimate date. I perhaps should mention that some of the cells in the column returned zero-length text because the
formula calls for that if the precedent cell is blank. I don't know if that affects anything.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html