my dates are all dd-mmm-yy (24-Jan-07).21-Dec-01
24-Jan-07
14-Apr-03
The above are "pasted" examples. I've tried custom filters eg;
"contains" Jan, *Jan* (I've also tried other months)
"ends with" 07 *-07 (Ive tried other years)
When I try these custom filters the filter runs and then gives me an empty
screen with "0 of xxxxx records found" down below in status line and the
first line of the worksheet is the first line below the last line of
available information eg. "if my whole worksheet is 40325 rows long then the
filtered results shows the first line at 40326 without any data. I can't
scroll up any further in the worksheet until AFTER I remove the filtering
information or select "All" from the drop down. (I can scroll down but not
up).
Thanks,
Brad


"Roger Govier" wrote in message
...
Hi Brad

What Custom filter are you trying to apply?
What is the type of data ( a few examples) that is contained within that
column?

--
Regards

Roger Govier


"Brad" wrote in message
...
Obviously that's one of excels weak points. Why can't I get the
"custom"
filter to work?
I've done custom filters on the information that's in the drop down
list
and still I get nothing.

"Roger Govier" wrote in message
...
Hi Brad

Autofilter will only show the first 1000 filtered rows.
Debra Dalgleish has some workarounds on her site at
http://www.contextures.com/xlautofilter02.html#Limits

--
Regards

Roger Govier


"Brad" wrote in message
...
I've got a worksheet that has a column of dates (eg. 24-Jan-07)
they
are
different days, different months and different years with some
repeating.There are over 47000 rows so I have a lot of data. I am
trying to
auto-filter this column but when I click on the down arrow it
doesn't
list
ALL of the possible dates that are available. Also, when I do a
"custom"
filter for information I know is there (eg. ends with "07") it
doesn't
pull
any information at all yet the worksheet page shows it's located at
the
first row below the last available row of data (eg. I have 47802
rows
it
says it's at row 47803 after running the custom filter) I can't
scroll
up to
view any rows above that line until I undo the "auto filter"
settings
I've
chosen (puzzled on that). It appears my "data-auto filter" and /or
"custom
filtering" isn't working properly. Is there a know issue with this?
I've
never had this problem before. Brad