filter 10 items from a list of 100
Use the advanced filter, as criteria range you can use
Header
a
b
f
h
k
where Header is the name of the header and a, b, f, h, k are 5 values you
want to filter for, you obviously would have 10 values. Then select the
table, do datafilteradvanced filter, preferably use copy to another
location, as criteria range use the range where you put your criteria, for
example
$H$1:$H$11
--
Regards,
Peo Sjoblom
"BillO" wrote in message
...
I have a list in excel with over 100 items, I wish to select only 10 of
these
to chart, the auto filter only provides 2 items any ideas???
|