Autofilter bug?

M

mikebo

I have a sheet with several hundred lines. When I activate Autofilter, I am
missing some entries in the value list. I can clearly see them in the sheet,
but not in value list. Is this a bug, and is there perhaps a fix? I am using
Excel 2000 SP3.

mike
 
J

JulieD

Hi Mike

basically, when you click an AutoFilter arrow, a list is displayed of the
items in the column, in alphabetical or numeric order, up to a total of
1,000 items ...

so could it be that you didn't realise the list was in alpha order and your
items are further up / down the list than you expect. Otherwise, do you
have any completely blank rows in your data area ... if you do excel is
probably only using the data up to the blank line when generating the list.

let us know how you go ...
 
C

CyberTaz

Hello Mike-

Are you taking into consideration that the AutoFilter List only shows
_Unique_ occurrences of the values in the column? i.e., no matter how may
times 'xxx' appears in your data, 'xxx' will only show up once in the list.

Regards |:>)
 
M

mikebo

Hi Julie,

The item I am looking for starts with a "G". I have 10 or so other items
that start with a "g" or "G", and they are all listed together
alphabetically, but not this one. I actually have a screenshot that shows the
problem, but I don't know if there is a possibility to upload the picture
somewhere.
If I do a custom filter, Excel finds the entry, but it's definitely not in
the list. Now, what happens if you have more than 1000 entries? How does
Excel decide which ones to show and which ones not to show? I checked the
sheet, and there are actually more than 2000 lines, so there is a slight
possibility that Excel finds more than 1000 entries.
 
D

Dave Peterson

Excel likes to remove the leading and trailing spaces when it generates this
list for the dropdown.

But if you have a different character--like a non-breaking space (common when
copying and pasting from a Web page), xl will keep that char(160).

I'd look to see if there was something else in that cell. In fact, I'd use Chip
Pearson's CellView addin that will show what each character is:
http://www.cpearson.com/excel/CellView.htm
 
M

mikebo

Not really. I downloaded the cellview macro and it shows me exactly what I
read in the sheet. How does Autofilter deal with capitalization? If I have
"gadget" and "Gadget", will it show up as two different items, or just one?

mike
 
Top