@Rennuka, Is it that you need to sort as well as filter the data? Because picking out selected grades forms a part of filtering whereas to show them in sorted order is sorting. Well, to pick out selected grades, you will be able to view only 2 at once. E.g. Students have grades assigned as A,B,C and so on,. Then, in this case, you will be able to select students having grades as A or B. To achieve this, 1. Apply autofilter in excel. Then you will find that a drop-down has been created at the headers of your table. 2. Open the drop-down using Alt+Down arrow key. 3. Go to custom... option. 4. Select "equals" option from combobox. 5. Tab to the textbox next to it and type "A". 6. Tab again to radio buttons labelled as "And" and "Or". Select the "Or" option. 7. Tab again and you will get a similar combobox where you select "equals" again. 8. Now tab again and type "B" in the second textbox and select "Ok"
That's it. Its done. HTH Siddhant On 4/29/11, Siddhant Chothe <[email protected]> wrote: > Hello there, > Can you specify what exactly you haven't understood? > In the mean while, here's an explanation of how filters work. > 1. Assume a table in excel having 3 columns:- Empno, Empname and > Empaddress as column headers. > 2. The sample data in this table is empno=1, empname=Amiyo and > Empaddress=India; empno=2, empname=Siddhant and Empaddress=India; > Empno=3, Empname=John and Empaddress=USA. > 3. Now if you apply autofilter on this table, then you will get > drop-downs automatically formed at the column headers. Openning these > drop-downs, you will get a list of unique values that fall under that > column (e.g. Empaddress will have India and USA as values in the > drop-down) > 4. Selecting one of the values will display only those records that > match the filter criteria. (e.g. Selecting India will show only > records for Siddhant and Amiyo whereas hide the record for John) > > > HTH > Siddhant > On 4/29/11, Amiyo Biswas <[email protected]> wrote: >> Hello, >> >> One of my friends asked me on using autofilter and advance filter in >> Excel. >> I did not make out anything of it. I am using Jaws11 on office 2003. >> Please >> help. I shall meet my friend tomorrow or on Sunday. So, it's urgent. >> >> Best regards, >> Amiyo Biswas >> Cell: 91-9433464329 >> To unsubscribe send a message to >> [email protected] >> 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 >> >> > To unsubscribe send a message to [email protected] 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
