| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Hybrid Mode
