"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
--