http://blogs.office.com/b/microsoft-excel/archive/2012/06/20/learn-excel-advanced-filters.aspxMany of you already know how to use Excel's AutoFilter feature to do basic data-sorting; for example, how to use it to select a single name from a long list of names. But what if you want to do more advanced filtering? Excel's Advanced Filter featureen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/06/20/learn-excel-advanced-filters.aspx#32356Fri, 27 Jul 2012 17:21:51 GMT53587256-c606-4c9b-bad4-97c86b12ce62:32356Courtney Owen<p>Hi Ankur, that&#39;s a great question, and I think a good topic for an upcoming post. &nbsp;Let me do some research and see if I can find the answer to your question. &nbsp;In the meantime, you may want to contact <a rel="nofollow" target="_new" href="http://answers.microsoft.com">http://answers.microsoft.com</a> for assistance. &nbsp;Also, I apologize for taking so long to respond to your comment. &nbsp;We were having some issues replying to comments, but that has now been resolved. &nbsp;Cheers, Courtney</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=32356" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/06/20/learn-excel-advanced-filters.aspx#31503Thu, 21 Jun 2012 08:14:41 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31503excelpro<p>could you explain how do we apply multiple filters in a single worksheet without affecting each others?</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31503" width="1" height="1">