Autofilter bug?
 

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

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 ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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

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 |:)

"mikebo" wrote:

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

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.

"JulieD" wrote:

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 ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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

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



mikebo wrote:

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.

"JulieD" wrote:

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 ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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




--

Dave Peterson

Hi

Did Dave's suggestion solve the problem?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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.

"JulieD" wrote:

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 ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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

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

"JulieD" wrote:

Hi

Did Dave's suggestion solve the problem?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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.

"JulieD" wrote:

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 ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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

Hi Mike

they will show up as one item ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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

"JulieD" wrote:

Hi

Did Dave's suggestion solve the problem?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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.

"JulieD" wrote:

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 ...

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mikebo" wrote in message
...
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