Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
Filter icon | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Custom Filter Problem | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel |