If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filters
I want to know how to make use of filters, i have a column called age, i want
to filter out to different ages groups, like between 24-34 one and other 45-54. how to do that. |
#2
|
|||
|
|||
filters
On the "Age" col,
Try Data Filter Autofilter Custom Set it as, for example: "is greater than or equal to" : 24 And "is less than or equal to" : 34 Click OK (Above filters age: 24-34 inclusive) Try also Debra Dalgleish's nice coverage on Autofilter & Advanced Filter at her: http://www.contextures.com/tiptech.html Autofilter - Basics Autofilter - Filter ... ...... Filter, Advanced Filter, Autofilter -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "acess" wrote in message ... I want to know how to make use of filters, i have a column called age, i want to filter out to different ages groups, like between 24-34 one and other 45-54. how to do that. |
#3
|
|||
|
|||
filters
Thank you for reply, let me tell you that i have listed ages groups in number
like Age:- 18-24 = 1 25-34 = 2 35-44 = 3 45-54 = 4 55-64 = 5 and i want the age col to only show the age group 2 and 4 by using filter or is there any other method. Abhilekha "Max" wrote: On the "Age" col, Try Data Filter Autofilter Custom Set it as, for example: "is greater than or equal to" : 24 And "is less than or equal to" : 34 Click OK (Above filters age: 24-34 inclusive) Try also Debra Dalgleish's nice coverage on Autofilter & Advanced Filter at her: http://www.contextures.com/tiptech.html Autofilter - Basics Autofilter - Filter ... ...... Filter, Advanced Filter, Autofilter -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "acess" wrote in message ... I want to know how to make use of filters, i have a column called age, i want to filter out to different ages groups, like between 24-34 one and other 45-54. how to do that. |
#4
|
|||
|
|||
filters
"acess" wrote
.. listed ages groups in number like Age:- 18-24 = 1 25-34 = 2 35-44 = 3 45-54 = 4 55-64 = 5 and i want the age col to only show the age group 2 and 4 by using filter or is there any other method. We can still use autofilter on the column with the age gp numbers, with change in criteria setting Assume the numbers are in col C, data from row2 down Select C1, click Data Filter Autofilter Select "Custom" from the autofilter droplist in C1 In the Custom Autofilter dialog set it as: "equals" : 2 Or ( select "Or") "equals" : 4 Click OK The above should filter out only those lines with age gp #s: 2 and 4 in col C -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
filters logics | abarwinski | Worksheet Functions | 0 | September 16th, 2005 11:53 AM |
Clear Filters | Aaron | General Discussion | 6 | June 18th, 2005 12:13 AM |
Export to Excel using filters | Desmond | Using Forms | 0 | June 17th, 2005 12:04 AM |
advance filters | Manuel Toubes | General Discussion | 4 | October 3rd, 2004 06:19 AM |
Printing applied filters | Sandro | Worksheet Functions | 2 | June 3rd, 2004 04:33 AM |