ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i filter out data?? (https://www.excelbanter.com/excel-worksheet-functions/71711-how-do-i-filter-out-data.html)

lawrence

How do i filter out data??
 
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.

Peo Sjoblom

How do i filter out data??
 
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.




All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com