Hi Renuka, In excel 2003 you can only see 1000 unique items in autofilter,however in excel 2007 and 2010 you can view upto top 10001 unique items in Autofilter.
In your case, You should use simple sort or Pivot table to manage your large data set. I hope it helps. Thanks. Best Regards, Ayush Jain Microsoft MVP -- ---------------------------------------------------------------------------------- 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
