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 |
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 |
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 |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com