Thread: filters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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.