Hello Siddhant,
Thank you for the help. Though I was able to use advance filter with simple
criteria, I could not locate the drop-down box. I was expecting it somewhere
on the toolbar. Now I found it. Actually, jaws does not announce the drop
down menu. On the column heading cell, I had to press alt+down arrow to open
the drop down box. I press arrow key to choose an option and hit the enter
key on the choice to activate it.
Thank you once more.
With best regards,
Amiyo Biswas.
Cell: 9433464329
----- Original Message -----
From: "Siddhant Chothe" <sidnc1...@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Friday, April 29, 2011 11:22 AM
Subject: Re: [AI] Filter in Excel.
@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 <sidnc1...@gmail.com> 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 <amiyo.bis...@gmail.com> 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
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
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
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
