Excel 2003 doesn't filter correctly

T

tclarke012

All of a sudden I can't filter a colum correctly. I use filtering to find
records that have been "started", "done", "cancelled", "paid", etc. I have
made sure that the colum is formated for text. When I use the filter I get
other unwanted records in addition to my filter request. This seems to only
be happening on a summary sheet in 1 workbook. The other sheets seem to
filter just fine. I have had no problem for the last 6 months using filters
with this workbook until recently. Does anybody else have this situation?
 
D

Dave Peterson

Do those extra things show up at the bottom of good stuff?

If yes, look at the row numbers for those cells. If they're grey, then those
rows were not a part of the filtered range. If they're blue, then this isn't
the problem.

I don't let excel guess my range to filter (or sort or chart or ...). I select
my cells explicitly and then do Data|filter...
 
T

Tom

filters don't work if you have a blank row in between
have you checked that too?

~tom
 
Top