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

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.