Autofilter Not working completely

S

Steve

Here are the specifics:
- Using Excel 2003
- Have several workbooks which were built alike.
- Set autofilter on all of the columns which is about 10.
- The number of rows is about 40
- There is a row of data then a row that is a merge and center cell that
spans all ten columns. This row is filled in with color which is used as a
visible separator and a data descriptor. The data row and separator
alternates down the spreadsheet.

Four of the six workbooks without problems. When working the autofilter,
once a criteria is selected, will display only those rows that match the
criteria. It excludes all rows that don't match to include the separator
rows.

However, for some reason two of the workbooks don't filter all the data. It
filters a subset of the data which are grouped in consecutive rows at the
top, but it also continues to display the separator rows and other rows that
don't match. There are rows further down that do match the criteria but are
not grouped at the top and are displayed in the normal order. This scenario
occurs for each column within the worksheet. Is there some way that rows
after a certain point are excluded from the filter? If so, how is this done
and how can I correct it? Is there a way to visually see any conditions or
restrictions that may be in place. Similar to the Paragraph button in MS
Word where it shows you all the hidden characters (spaces, carriage returns,
etc.).

Thanks in advance for your assistance.

Steve
 
M

Max

- Set autofilter on all of the columns which is about 10.

To avoid ambiguity, I'd select the entire cols -- not just the top row
cells, then apply autofilter. Or, select the entire range including the top
row cells, then apply autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
 
S

Sninkle

If there is a blank row between data, auto filter will ignore everything
after the blank row.
 

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

Top