Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000 filter problems
I have inherited a large excel file nearly 4000 rows long
The first column is a reference number and can be between 1 and 750 inclusive. For information, the number repesents an electronic programable key for use in a computerised fuel monitoring / issue system. The other columns are used to record what vehicle is set up against each key, other columns record similar data, ie. user departments, fuel type etc. If a fuel key is returned it can be reprogramed with different references, the details of the original references are kept in the spreadsheet. Therefor if a filter is applied to the first column for say key number 5, all rows with the figure 5 in the first column should be displayed. Unfortunately all rows are not shown, is there a limit to the number of rows allowed in a spreadsheet. There does not appear to be any blanks in the first column. If for instance I enter a unique figure in the first column of the row following the last row this is picked up when applying a filter I know excel is not the best way of recording this data but as stated I inherited the spreadsheet Many Thanks Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000 filter problems
The dropdown will show up to 1000 items, for possible workarounds
http://www.contextures.com/xlautofilter02.html#Limits -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Steve Walford" wrote in message ... I have inherited a large excel file nearly 4000 rows long The first column is a reference number and can be between 1 and 750 inclusive. For information, the number repesents an electronic programable key for use in a computerised fuel monitoring / issue system. The other columns are used to record what vehicle is set up against each key, other columns record similar data, ie. user departments, fuel type etc. If a fuel key is returned it can be reprogramed with different references, the details of the original references are kept in the spreadsheet. Therefor if a filter is applied to the first column for say key number 5, all rows with the figure 5 in the first column should be displayed. Unfortunately all rows are not shown, is there a limit to the number of rows allowed in a spreadsheet. There does not appear to be any blanks in the first column. If for instance I enter a unique figure in the first column of the row following the last row this is picked up when applying a filter I know excel is not the best way of recording this data but as stated I inherited the spreadsheet Many Thanks Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000 filter problems
Thanks
Answered the question Steve On Wed, 7 Jun 2006 13:46:20 -0700, "Peo Sjoblom" wrote: The dropdown will show up to 1000 items, for possible workarounds http://www.contextures.com/xlautofilter02.html#Limits |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
In EXCEL 2000, when using the Filter feature | Excel Worksheet Functions | |||
Excel 2000: Lines hidden with filter | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Problems downloading Excel 2000 templates | New Users to Excel |