Hello,
Siddhant of our list wrote estensively on Excel filter on this list some
days back. I saved his messages in a text file. I am copying the text below.
The messages are separated by 3 equal signs.
With best regards,
Amiyo Biswas
Cell: +91-9433464329
On 4/29/11, Siddhant Chothe <[email protected]:
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
===
Custom option in autofilter
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
----- Original Message -----
From: "B. R. Nautial" <[email protected]>
To: "Access India" <[email protected]>
Sent: Thursday, October 13, 2011 7:57 PM
Subject: [AI] Need Information About Filter Submenu of Excel Sheet
Hello dear friends,
Can any one of you explain me the different commands under the Filter
Submenu in excel sheet?
Thanks in Advanced
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/[email protected]/
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
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/[email protected]/
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
