Custom filtering of rows

  • Thread starter Thread starter Rita Palazzi
  • Start date Start date
R

Rita Palazzi

Windows XP Professional
Office 2000


I have a monthly worksheet with data input for each day of the month
that is set up with autofilters. When I try to do a custom filter to
show only a certain range of days, it goes to a complete blank with a
label for "Grand Total" and all fields are zero.

Is there a trick to applying custom filters?

Any help you can give is appreciated!

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express
 
Hi
are you sur your date values are really stored as date values and not
as 'Text' values?
 
They actually are text values because the format is yyyymmdd, but can't
you filter on a text field?

Thanks!
Rita
 
Hi
you can but not so easy if you want to search for a specific month
only). This would require for exampl a helper column with the formula
=--MID(A1,5,2)
and filter with this column
 
You could use a Custom AutoFilter to filter the field. For example, to
filter for September, if the "dates" have been entered as text:

From the dropdown list in the Date field heading, choose Custom
From the first dropdown, choose: is greater than or equal to
In the text box, type: '20040901
Select the And operator
From the second dropdown, choose: is less than or equal to
In the text box, type: '20040930
Click OK
 
Back
Top