View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] arogg@payroll.nyc.gov is offline
external usenet poster
 
Posts: 6
Default Advanced filter dates and nulls

On Jul 17, 8:52 am, JoHickey
wrote:
I would like to use the advanced filter to return all dates greater than
April 1, 2007 or are null. I cannot seem to incorporate the two together.

Any help would be appreciated

Thanks


You need to set up two criteria rows, with the "greater than"
condition in one and the null condition in the other.

Allan Rogg