Filter problem

srmorgan · Apr 19th, 2002, 03:18 PM

I have a new spreadsheet with 22 columns and 16,000 records.
I need to use the data filter to examine data in the cells and find empty fields or incorrect data.
The problem is that when I filter a column, not all of the values in the column are showing up in the filter box. It appears not to be accepting the highest values in the column. When I do a custom filter, say all values over $300, the higher values in the column do appear.
Is there a limitation on the number of records that one can filter.

Any feedback is appreciated.

Steve Morgan
North Carolina

daleyman · Apr 19th, 2002, 03:34 PM

There is no limit. You might want to start by ensuring that all cells in that column are the same format with numeric values throughout. Find a line that does not appear in filtered list that it should, and check those cells out...

Mark W. · Apr 19th, 2002, 04:10 PM

While there's no limit to the number of records that can be filtered (other than the row limits of the worksheet itself), the filter drop down list will only show the 1st 1,000 unique values. You can circumvent this limit by using a Custom AutoFilter or an Advanced AutoFilter.

Apr 19th, 2002, 03:34 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	There is no limit. You might want to start by ensuring that all cells in that column are the same format with numeric values throughout. Find a line that does not appear in filtered list that it should, and check those cells out... __________________ <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;">*DALEY :P**</td></table>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 03:18 PM	#1
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	I have a new spreadsheet with 22 columns and 16,000 records. I need to use the data filter to examine data in the cells and find empty fields or incorrect data. The problem is that when I filter a column, not all of the values in the column are showing up in the filter box. It appears not to be accepting the highest values in the column. When I do a custom filter, say all values over $300, the higher values in the column do appear. Is there a limitation on the number of records that one can filter. Any feedback is appreciated. Steve Morgan North Carolina

Apr 19th, 2002, 04:10 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	While there's no limit to the number of records that can be filtered (other than the row limits of the worksheet itself), the filter drop down list will only show the 1st 1,000 unique values. You can circumvent this limit by using a Custom AutoFilter or an Advanced AutoFilter.