Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
autofilter | Excel Worksheet Functions | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |