Next time you filter to show the FTS cells, take a look at the row numbers of
the visible rows.

You'll see that the rows included in the range are colored blue. My bet is that
the rows that you see that don't match your criteria are still grey.

This means that those rows are not part of the autofilter range.

Remove the filter and select the whole range (Don't let excel guess at it!) and
then reapply data|filter|autofilter.

Like Dann suggested, empty rows can make excel guess at the wrong range. If you
select the range first, you shouldn't have those kinds of problems.



strictly_rhythm wrote:

Hi could someone please help me?

Ive been using Microsoft Excel Spreadsheet to set up a product order
list with different abbreviated codes for each product. eg: FTS CFT
etc..

Now I use the auto-filter to seperate the lists of both products in the
one column, which previously has divided them ok. This time however Im
a bit confused as when I click on the auto-filter bar for the product
column and choose to view one type of product for some reason it lists
about 40 rows of the same product code ie: FTS FTS FTS then after the
40th cell it mixes the products up again when I only requested to see
one type of product. For siome reason it doesnt seem to be computing
the same request after a certain row????

Why is this happening?? Does anyone know what the problem could be and
how it can be solved?

Id very much appreciate any help,

Many Thanks

Steve

--
strictly_rhythm
------------------------------------------------------------------------
strictly_rhythm's Profile: http://www.excelforum.com/member.php...o&userid=36002
View this thread: http://www.excelforum.com/showthread...hreadid=557886

--

Dave Peterson