Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting items in auto filter - how? | Excel Discussion (Misc queries) | |||
How do I filter for items that end in % | Excel Discussion (Misc queries) | |||
can you filter more than two items in excel 2000 | Excel Worksheet Functions | |||
Filter based on a column of items | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |