Excel 2003:- You can see only 1000 records in the Autofilter Dropdown. Not more than that.
Excel 2007/2010:- You can see 10000 records in the Autofilter Dropdown. Not more than that. So try to use some helper column based on your data criteria use some formula in helper column like Istext, Isnumber, Isblank, which will make the output as boolean and the result will be True or False and if you apply the auto filter for that then your drop down will show only 2 records True / False and you will be having another (Excel 2003-998 in your hand to show in Autofilter Dropdown) (Excel 2007/2010-9998 in your hand to show in Autofilter Dropdown) and you can try len function also. So it's purely based on the data and your requirement and how you use the functions. Hope it's clear and helpful to you! ----------------------- Ms.Exl.Learner ----------------------- On Wed, Dec 22, 2010 at 8:58 PM, renuka chari <jva.ch...@gmail.com> wrote: > hi > good evening to all experts > > currentely i am trubling in large range data with filtaration > > my company data having nearly 4lac of rows in one file > > i need to sort that data using auto filter Option then it was not > showing all filterd data i don't know how to filter that large rang of > data > can u help me any one > if possible give me example > > thanks in advance > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
