Google Answers Logo
View Question
 
Q: Excel autofilter bug? ( No Answer,   4 Comments )
Question  
Subject: Excel autofilter bug?
Category: Computers > Software
Asked by: rbnn-ga
List Price: $15.00
Posted: 03 Aug 2005 12:04 PDT
Expires: 02 Sep 2005 12:04 PDT
Question ID: 551304
I used autofilter in Excel 2002 on a spreadsheet with 10,000 rows and
about 15 columns. I then went to the drop-down box associated with one
of the columns, say customer, and scrolled through it. A customer that
I know is in the spreadsheet in the associated column was not listed,
although normally the drop-down box associated with a column lists all
the unique entries in that column. Is this a known bug, or am I
misunderstanding something, and what is the fix if any?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Excel autofilter bug?
From: nelson-ga on 03 Aug 2005 19:16 PDT
 
Are you sure there are no blank rows before the row containing that
customer?  Did you do a find (Ctrl + F) to verify that it is in the
spreadsheet?
Subject: Re: Excel autofilter bug?
From: rbnn-ga on 03 Aug 2005 21:30 PDT
 
Yes, there are no blank rows before the row in question and the row is
indeed in the spreadsheet, although I checked it manually and not with
Ctrl-F.
Subject: Re: Excel autofilter bug?
From: jack_of_few_trades-ga on 04 Aug 2005 09:24 PDT
 
I had the same problem recently with a similar sized spreadsheet.  I
am almost certain now that the filter has a limit to how many unique
values it will display.
I haven't checked closely into the situation, but I'd imagine it shows
the first 50 (50 is a guess and an arbitrary #) unique values in the
column.
Subject: Re: Excel autofilter bug?
From: myexpertsonline-ga on 06 Aug 2005 13:09 PDT
 
Autofilter will only show 1,000 unique entries. So, while you may have
10,000 rows, if there's not an average of 10 entries each, you won't
see them all. You must use the Custom option under Autofilter to
search for one that doesn't show.

~Anne Troy

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy