filter 10 items from a list of 100
 

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???

filter 10 items from a list of 100
 

use a helper column and put one by the ones you wish to chart, use
autofilter on the helper column and 1

"BillO" wrote:

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???

filter 10 items from a list of 100
 

Hi Bill,

Which 10 do you wish to use?
One possibility with your data in A1 to A100 put this formula in B1 and
copy down to B10.
=INDEX(A:A,ROWS($1:1)*10)
This will place every tenth value into column B.

HTH
Martin

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???