B
BillO
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???
to chart, the auto filter only provides 2 items any ideas???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bj
use a helper column and put one by the ones you wish to chart, use
autofilter on the helper column and 1
autofilter on the helper column and 1
M
MartinW
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
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
P
Peo Sjoblom
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 data>filter>advanced filter, preferably use copy to another
location, as criteria range use the range where you put your criteria, for
example
$H$1:$H$11
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 data>filter>advanced filter, preferably use copy to another
location, as criteria range use the range where you put your criteria, for
example
$H$1:$H$11