Thread: Filters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Filters

EXCEL 2007

Yes it is possible.

1. Turn on filters at the top pf your data (Data / Sort & Filter group /
click on Filter).

2. Go the the column in which your dates are found and click on the filter
drop down arrow / Date Filters / Between / in the Custom AutoFilter pop up
window that appears select the dates between which you wish to search / OK

This should give you hwat you want.

If my comments have helped please hit Yes.

Thanks.





"SarahN" wrote:

Hi

I am wondering is it possible to set a filter to select a Date Range.

I have a group of dates however need to look at only the ones from 01st May
2009 - 30th April 2010.

I have experimented with the advanced filters and cant figure it out. Also
these are seperated with blank rows, Is it possible to select all data and
use a filter this way?