#1   Report Post  
Old November 29th 04, 04:08 PM
Aaron Neunz
 
Posts: n/a
Default EXCEL AUTOFILTER

Hello,
I have an Excel spreadsheet with 5657 records. When I use the autofilter
feature to filter by, for example, the last name column I only receive 1586
records in the drop down box. What gives?



  #2   Report Post  
Old November 29th 04, 04:12 PM
Frank Kabel
 
Posts: n/a
Default

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Aaron Neunz" schrieb im Newsbeitrag
...
Hello,
I have an Excel spreadsheet with 5657 records. When I use the

autofilter
feature to filter by, for example, the last name column I only

receive 1586
records in the drop down box. What gives?





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 Autofilter - limitations? Kschu Excel Discussion (Misc queries) 3 April 19th 05 09:07 PM
Windows search in Excel with autofilter Dave Z Excel Discussion (Misc queries) 1 January 21st 05 07:44 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Using AutoFilter In Excel, I can't get Excel to recalculate only . Sheryl Excel Discussion (Misc queries) 3 December 8th 04 09:17 PM


All times are GMT +1. The time now is 01:46 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017