Custom filtering of rows

[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

 

[Frank Kabel]

Hi
are you sur your date values are really stored as date values and not
as 'Text' values?

 

[Rita Palazzi]

They actually are text values because the format is yyyymmdd, but can't
you filter on a text field?

Thanks!
Rita

 

[Frank Kabel]

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

 

[Debra Dalgleish]

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

 

[Rita Palazzi]

Excellent! That worked like a charm! thanks so much!!!