Hi, I wanna tell you that fillter work in nested (One inside another) manner. Means after you apply one filter on a data the remaining data is according to you filter criteria. After this if you apply another filter ( Without removing the first one) then the filter is according to your first criteria then your second criteria. Means if you filtered (excluded or hide by filter) some rows in your first filter then your second filter cannot check those filtered or hidden value for its criteria.
So when you apply second filter your first filter don't go away but your second filter don't equals with your first filter criteria and you get some more rows hidden. This technique of multiple filter is useful when you need to find values in which one column value is depend upon another column value. e.g. if you want to find Sunil in delhi in your data. which has many cities in one column say column A and names in another Say column B then you can filter the column A for delhi and then apply filter for contains sunil in column B you will get all sunil who lives in delhi. Thanks & Regards Sandeep ----- Original Message ----- From: big smile To: EXCEL MACRO GROUP Sent: Thursday, September 24, 2009 10:21 AM Subject: $$Excel-Macros$$ 2 FILTER IN SINGLE SHEET Hellow group members, Have a nice time with excel master. I have query that can it possible to have 2 filer option in single sheet.- if yes how can be done. with the helo of macro or without the help of macro. I have tried one filter -- then i have added another filer on another raw - then 1 st filter goes. J. C. Shah. Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 -~----------~----~----~----~------~----~------~--~---
