filter
 

Is there a way to filter data by a range? i have groups of data that consist
of ten rows that i want to be able to select which set of data i want to look
at/.

--
Message posted via http://www.officekb.com

filter
 

Yes, look at DataFilterAutofilter

So select a range, you will need to use the Custom... option in the appropriate
column.

--
Regards,
Fred


"TimB via OfficeKB.com" <u32108@uwe wrote in message news:6f639d24f7c7c@uwe...
Is there a way to filter data by a range? i have groups of data that consist
of ten rows that i want to be able to select which set of data i want to look
at/.

--
Message posted via http://www.officekb.com

filter
 

How can i select a range with the custom filter?


Fred Smith wrote:
Yes, look at DataFilterAutofilter

So select a range, you will need to use the Custom... option in the appropriate
column.

Is there a way to filter data by a range? i have groups of data that consist
of ten rows that i want to be able to select which set of data i want to look
at/.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200703/1

filter
 

Choose the filter by clicking on the down arrow.
Choose Custom...
Choose Greater Than in the first box
Enter the low range in the second
Choose And
Choose Less Than in the third box
Enter the high range in the fourth


--
Regards,
Fred


"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6f693ececa269@uwe...
How can i select a range with the custom filter?


Fred Smith wrote:
Yes, look at DataFilterAutofilter

So select a range, you will need to use the Custom... option in the
appropriate
column.

Is there a way to filter data by a range? i have groups of data that
consist
of ten rows that i want to be able to select which set of data i want to
look
at/.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200703/1