One simple alternative ..
Assuming source list in row2 down, dates in B2 down
In C2: =IF(B2="","",TEXT(B2,"mmmyy"))
Copy down, then just apply autofilter on col C for the desired functionality
to easily filter dates by month/yr.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"FARAZ QURESHI" wrote:
Suppose I have same sort of list as follows:
CASE1 01-JAN-08
CASE2 15-JAN-08
CASE3 01-FEB-08
CASE4 31-MAR-08
CASE5 15-MAR-08
I have a list of months i.e. January to December presented in list option at
C1 upon selecting March, I want the list in D1 to be reflecting the options
of only 31-MAR-08 and 15-MAR-08 i.e. dates falling in March
--
Best Regards,
FARAZ A. QURESHI