 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006Auto Filter problems...
I am trying to use the auto filter function on a sheet that has about 47000 rows in it. The column I want to auto filter has about 14900 different values in it. So many of the values are repeated. The problem is that when I open the auto filter, all of the different values are not available. Only the first 1000 of them. Is this normal? Is it a limitation of the auto filter function? I can use custom and pull the info that I need, so that is working. Just curious... Steven K.  SignatureSteven Keeling Pal Services DSCR Richmond VA Yes AutoFilter has a limit of 1000 unique items. Have a look at the following link for additional information: http://www.contextures.com/xlautofilter02.html#Limits SignatureRegards, Dave > I am trying to use the auto filter function on a sheet that has about 47000 > rows in it. The column I want to auto filter has about 14900 different [quoted text clipped - 7 lines] > > Steven K. Ah, that's what I thought. I had just never ran into this situation before with that many unique records. Thanks!! Steven K. SignatureSteven Keeling Pal Services DSCR Richmond VA > Yes AutoFilter has a limit of 1000 unique items. Have a look at the > following link for additional information: [quoted text clipped - 11 lines] > > > > Steven K. The 1000 limit isn't really the autofilter's limit. It's the limit of how many unique entries show up in that dropdown. You can still filter (using custom and typing) to get any of the values in your list. > Ah, that's what I thought. I had just never ran into this situation before > with that many unique records. Thanks!! [quoted text clipped - 28 lines] > > > Pal Services > > > DSCR Richmond VA SignatureDave Peterson Yes, I had that figured out. I was just trying to fine another way to do it without going custom and typing it in. Thanks! SignatureSteven Keeling Pal Services DSCR Richmond VA > The 1000 limit isn't really the autofilter's limit. It's the limit of how many > unique entries show up in that dropdown. [quoted text clipped - 34 lines] > > > > Pal Services > > > > DSCR Richmond VA |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.