filter problem
 

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???? :confused:

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=557887

filter problem
 

Have you got any gaps in the data? I've seen autofilter have problems in
the past with this.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=557887