Autofilter problem unresolved
 

The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.

"Franz Erhart" wrote:

Hi Jamie,
I was able to duplicate your problem on my machine.
It has to do with the fact that some excel functions don't like it if there
are blank lines.
Check your data and remove blank lines, or sort them in a way the blank
lines are at the end of your 2000 lines.
This should do the trick.

"Jamie R" wrote:

The worksheet I am working on has over 2000 lines. I am having a problem
where the autofilter does not show all of my data. The drop down box does not
show all the different names I have in that specific column. I have tried
having them sorted in ascending order and all. The rows that contain that
information do not show on the drop down list.

Autofilter problem unresolved
 

Hi Jamie

There is a limit of 100 unique items in the dropdown
See Debra's site for more info
http://www.contextures.com/xlautofilter02.html#Limits


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jamie R" wrote in message ...
The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.

"Franz Erhart" wrote:

Hi Jamie,
I was able to duplicate your problem on my machine.
It has to do with the fact that some excel functions don't like it if there
are blank lines.
Check your data and remove blank lines, or sort them in a way the blank
lines are at the end of your 2000 lines.
This should do the trick.

"Jamie R" wrote:

The worksheet I am working on has over 2000 lines. I am having a problem
where the autofilter does not show all of my data. The drop down box does not
show all the different names I have in that specific column. I have tried
having them sorted in ascending order and all. The rows that contain that
information do not show on the drop down list.

Autofilter problem unresolved
 

Depedning on your lookup value, autofilter will only show a certain number of
items. You can find this out quickly by sorting by your desired column. If
your values end at, say, w, then you aren't capturing anything from y down.



"Jamie R" wrote:

The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.

"Franz Erhart" wrote:

Hi Jamie,
I was able to duplicate your problem on my machine.
It has to do with the fact that some excel functions don't like it if there
are blank lines.
Check your data and remove blank lines, or sort them in a way the blank
lines are at the end of your 2000 lines.
This should do the trick.

"Jamie R" wrote:

The worksheet I am working on has over 2000 lines. I am having a problem
where the autofilter does not show all of my data. The drop down box does not
show all the different names I have in that specific column. I have tried
having them sorted in ascending order and all. The rows that contain that
information do not show on the drop down list.

Autofilter problem unresolved
 

Hi,

this is version dependent.

2003 - 1000 unique items
2007 - 10,000 unique items

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Jamie R" wrote:

The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.

"Franz Erhart" wrote:

Hi Jamie,
I was able to duplicate your problem on my machine.
It has to do with the fact that some excel functions don't like it if there
are blank lines.
Check your data and remove blank lines, or sort them in a way the blank
lines are at the end of your 2000 lines.
This should do the trick.

"Jamie R" wrote:

The worksheet I am working on has over 2000 lines. I am having a problem
where the autofilter does not show all of my data. The drop down box does not
show all the different names I have in that specific column. I have tried
having them sorted in ascending order and all. The rows that contain that
information do not show on the drop down list.

Autofilter problem unresolved
 

The autofilter list will show only 1000 unique items.

Work around that limitation by using Custom and one of the parameters found
there.

i.e. starts with.........contains or similar.


Gord Dibben MS Excel MVP

On Wed, 3 Dec 2008 11:46:52 -0800, Jamie R
wrote:

The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.

"Franz Erhart" wrote:

Hi Jamie,
I was able to duplicate your problem on my machine.
It has to do with the fact that some excel functions don't like it if there
are blank lines.
Check your data and remove blank lines, or sort them in a way the blank
lines are at the end of your 2000 lines.
This should do the trick.

"Jamie R" wrote:

The worksheet I am working on has over 2000 lines. I am having a problem
where the autofilter does not show all of my data. The drop down box does not
show all the different names I have in that specific column. I have tried
having them sorted in ascending order and all. The rows that contain that
information do not show on the drop down list.