Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Abdullah Kajee
 
Posts: n/a
Default Why does excel not see more than 1000 lines in filter mode?

In large spreadsheets more than 1000 rows, I find that Excel ignores values
below the 1000th row? Am I doing someting wrong or is it a program error.
  #2   Report Post  
Ben McBen
 
Posts: n/a
Default

Some more context would be useful - are you talking about
in formulas? SOme example please
  #4   Report Post  
Mark Rosenkrantz
 
Posts: n/a
Default

It is the limit in Excel.

--
-------------------------
Rosenkrantz Spreadsheet Solutions
Witkopeend 24
1423 SN Uithoorn
Netherlands
-------------------------
T: (0297) 527511
E:
W:
www.rosenkrantz.nl
-------------------------

"Alan" wrote in message
...
"Abdullah Kajee" <Abdullah wrote in
message ...

In large spreadsheets more than 1000 rows, I find that Excel ignores
values below the 1000th row? Am I doing someting wrong or is it a
program error.


Neither.

That is the built in limit I believe.

Alan.




  #5   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi

Excel's autofilter dropdowns will display the first 1000 unique items to
choose from. That is a design choice and a limitation you have to deal with.
But autofilter will work fine with lists of any length or count, so those
values are not ignored. Try a Top 10 filter and you will get the ten
greatest values, whether they are in the dropdown or not.

HTH. Best wishes Harald



"Abdullah Kajee" <Abdullah skrev i melding
...
In large spreadsheets more than 1000 rows, I find that Excel ignores

values
below the 1000th row? Am I doing someting wrong or is it a program error.





  #7   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

An AutoFilter list will only show 1000 unique values, and there's no way
to increase that limit. However, there are a few workarounds he

http://www.contextures.com/xlautofilter02.html#Limits

Abdullah Kajee wrote:
In large spreadsheets more than 1000 rows, I find that Excel ignores values
below the 1000th row? Am I doing someting wrong or is it a program error.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #8   Report Post  
Alan Beban
 
Posts: n/a
Default

Abdullah Kajee wrote:
In large spreadsheets more than 1000 rows, I find that Excel ignores values
below the 1000th row? Am I doing someting wrong or is it a program error.


You might want to consider the ArrayRowFilter1 function in the freely
downloadable file at http://home.pacbell.net/beban

Alan Beban
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Filter Problem bkbrueggemann Excel Discussion (Misc queries) 3 February 2nd 05 12:49 AM
Excel Connector Lines JeffinDallas Charts and Charting in Excel 0 January 10th 05 06:01 PM
Using AutoFilter In Excel, I can't get Excel to recalculate only . Sheryl Excel Discussion (Misc queries) 3 December 8th 04 10:17 PM
Writing many lines on a same Excel 2000 cell freeposte Excel Discussion (Misc queries) 2 December 8th 04 03:45 PM
balance sheet template in excel adding lines JMJM Excel Discussion (Misc queries) 1 December 2nd 04 12:23 AM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"