Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter data by top 10 AND bottom 10 items simultaneously
How can I filter data to show the top 10 AND the bottom 10 items at the same
time? The Autofilter gives the option of one or the other but not both. My data is set out as shown below. I've used a macro to filter using advanced criteria for 'Sector' but I would like to be able to filter just by top x and bottom x number of items. Row 1: Value Sector Small Cap Row 5: Value Sector 6: -41 Industrial 7: -36 Small Cap 8: -34 Technology 9: 33 Industrial Any help is much appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why don't my filter results always appear on the bottom left? | Excel Discussion (Misc queries) | |||
In Excel how can I filter multiple columns SIMULTANEOUSLY? | Excel Discussion (Misc queries) | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
How to have a the liist items appear at the top, not bottom | Excel Worksheet Functions | |||
No filter results in bottom left hand corner | Excel Discussion (Misc queries) |