Hi, Ms Excel provides 2 ways of filtering data.
1. Auto Filter 2. Advanced Filter You need to select data that needs to be filtered before applying a filter. The Auto Filter option (Data > Filter > Auto Filter) is useful for filtering data on single column. When you select this option, it creates a drop-down list on top of selected columns. Place the cursor on the header cell of the auto filter column and press ALT+DOWN to open the list of options available for filtering on that column. The list of options differ depending the type of column like Text, Numbers, etc. Note that you can apply filter on multiple columns. If you apply a filter on column 1 and then column 2 then the filter on column 1 is retained. If you wish to apply a filter on column 2 without the one on column 1 then remove the filter on column 1. The Advanced Filter is useful when you wish to filter data wuth a complex logic. For example, consider the Employee list as in the Excel sheet (cell range A1:H11) at the following URL (I have uploaded the test data file on sendspace as it cannot be attached with this email): http://www.sendspace.com/file/9hb1hl Now if you are asked to fetch list of employees in the Sales department having 2 or more reportees and in the Marketing department having 5 or more employees, then enter filtering criteria as in the cell range K1:L3. Select cell range A1:H11. For this, press CTRL+G to open the GoTo dialog box. Enter A1:H11 and press Enter. Select Data > Filter > Advanced Filter. Enter the following values in the Advanced Filter dialog box: List Range: $A$1:$$11 (this field would be populated by default if you have selected the range) Criteria Range: K1:L3 (the $ sign would be appended by Excel) Activate the OK button and you can see rows of data meeting the specified criteria. Note that the Show All option helps you unhide all rows of data that were hidden due to filtering. Hope this gives you some idea of what Filtering in Excel is all about. On 10/14/11, B. R. Nautial <brnaut...@gmail.com> wrote: > Hello dear members > I am really sorry to say that I couldn't get the answer of my previous > question > My Question was: > Please Explain me about the Filter Commands, used in Microsoft Excel. > Thanks in Advance. > > With Regards > B. R. Nautial > Mobile: +91-9915073368 > Register for AccessIndia convention 2011(November 12-13) at: > http://www.accessindia.org.in/harish/convention.htm > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Register for AccessIndia convention 2011(November 12-13) at: http://www.accessindia.org.in/harish/convention.htm Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
