Hi Prashant,Unfortunately, excel can show you first 100 unique entries only in auto filter (It is hard coded in Excel)
Workaround can be pivot table. On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar <prashant...@gmail.com>wrote: > Dear all > > Thanks for the knowlege enrichment of excel by you all... > > I am facing problem with Filter. While filtering data I am not able to see > the data after specific cell. > See the filter range.bmp. > In the file i am not able to see the rows after value 3264.( see Book > master 2. worksheet in filter problem file) > > But If I am using custom filter for values above 3260 and the rows all rows > after 3260 can be views.( see Book master 3. worksheet in filter problem > file) > > My problem How I can see the values after 3264 in book master 2 worksheet ? > > > Thanks for your time . > > Waiting for your reply. > > Prashant. > > > > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
