Thread: Custom Filter
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Custom Filter

Try "Greater than or equal to" AND "Less than or equal to" as your Custom
Filter criteria.......

Vaya con Dios,
Chuck, CABGx3





"Shams" wrote:

Folks,
Here's a snapshot of a column:

Date
Jan-04
Feb-04
Mar-04
Jan-05
Feb-05
Apr-05
Jan-06
Mar-06

This column is formatted as Date. I am trying to do a custom filter where
it will only pick up, for example, January related dates i.e. Jan-04, Jan-05
& Jan-06.

How do I do this? I tried to do a custom with the "Begins With" parameter
but it doesn't return anything. Is this because the column is formatted as
Date and the Begins with normally work with text fields? Please help.

Regards,
Shams.