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
