Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lawrence
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Pull data - Advance Filter lil''bibbib Excel Worksheet Functions 1 June 29th 05 03:08 AM
Pivot Table Data Filter Problem Pepikins Excel Discussion (Misc queries) 0 June 16th 05 09:12 AM
Data Filter - Not all rows in spreadsheet will display in Autofilt Excel Help Excel Worksheet Functions 1 November 17th 04 05:40 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"