Add this array formula in a helper column, based upon the the numbers in
column A

=OR(ISNUMBER(N(MATCH(A2,SMALL(A:A,ROW(INDIRECT("1: 10"))),0))),ISNUMBER(N(MATCH(A2,LARGE(A:A,ROW(INDI RECT("1:10"))),0))))

and then filter by that column for TRUE

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dingo" wrote in message
...
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