Custom Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet which have Sales Record for the whole year. I tried to
filter for particular month according to date which is in column A from
01.04.06 to 31.12.2007.

I just want to filter data for the month of April, 06 than how i should use
data > filter > custom so that its reults come what i want.

Regards

RRS
 
Assuming the dates in your date column are real dates,
and your regional short date format is: M/d/yyyy

Autofiltering on the date column ..

Click Data > Filter > Autofilter > Custom
then make the settings under "Show rows where":

is greater than or equal to : 4/1/2006
And
is less than: 5/1/2006

Click OK

The above should filter out "data for the month of April, 06"
 
Thank you very much Max. You solved my problems several times. Thank you once
again.

yours

RRS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locate month and year from range of date from another sheet 3
Pivot table macro filter data between yesterday and today (date+time) 0
Macro to copy value in field and insert it into filter 2
Filter Column 1
Date Sum 2
Filter duplicates by multiple criteria 1
Applying filter on report 2
filtering 4

Back
Top