Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have just imported a data base from Dbase V into Excel worksheet. Can
anyone tell me how can i filter the birthday? I have a list of customer with their birth dates. Let's say i want a list of customer whose birthday falls on March. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Are the birthdays real numeric dates like 02/12/1970 etc?
If so you can use datafilterautofilter and use less than a certain date to get all birthdays after a certain date -- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "lawrence" wrote in message ... I have just imported a data base from Dbase V into Excel worksheet. Can anyone tell me how can i filter the birthday? I have a list of customer with their birth dates. Let's say i want a list of customer whose birthday falls on March. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pull data - Advance Filter | Excel Worksheet Functions | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |