Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can Excel find & sort one item in all the cells in a column?
Can Excel find & sort one item in all the cells in a column? My list
contains items that I want to assign to one or more categories in a single 'categories' column. If I assign a numeral to each category, then some items will have one numeral and some will have several. Is there a way to enter all the category numbers in ONE CELL for each item, and then make the filter read every entry that has a particular numeral in it (e.g., filtering for numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this filter work like a Word search, and can't figure out how to do it. Ideas? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can Excel find & sort one item in all the cells in a column?
Hi
With your dropdown for the filter in say column G, with a header in row 1, select the dropdown Custom =--LEFT(G2)=1 -- Regards Roger Govier "AHSinVT" wrote in message ... Can Excel find & sort one item in all the cells in a column? My list contains items that I want to assign to one or more categories in a single 'categories' column. If I assign a numeral to each category, then some items will have one numeral and some will have several. Is there a way to enter all the category numbers in ONE CELL for each item, and then make the filter read every entry that has a particular numeral in it (e.g., filtering for numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this filter work like a Word search, and can't figure out how to do it. Ideas? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can Excel find & sort one item in all the cells in a column?
I'm missing something here. What is the 'dropdown for the filter'? I can't
seem to do anything that gives me a 'custom' option. Newbie at this. "Roger Govier" wrote: Hi With your dropdown for the filter in say column G, with a header in row 1, select the dropdown Custom =--LEFT(G2)=1 -- Regards Roger Govier "AHSinVT" wrote in message ... Can Excel find & sort one item in all the cells in a column? My list contains items that I want to assign to one or more categories in a single 'categories' column. If I assign a numeral to each category, then some items will have one numeral and some will have several. Is there a way to enter all the category numbers in ONE CELL for each item, and then make the filter read every entry that has a particular numeral in it (e.g., filtering for numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this filter work like a Word search, and can't figure out how to do it. Ideas? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can Excel find & sort one item in all the cells in a column?
Apply datafilterautofilter, since you mentioned filter Roger assumed that
you already had it applied -- Regards, Peo Sjoblom Portland, Oregon "AHSinVT" wrote in message ... I'm missing something here. What is the 'dropdown for the filter'? I can't seem to do anything that gives me a 'custom' option. Newbie at this. "Roger Govier" wrote: Hi With your dropdown for the filter in say column G, with a header in row 1, select the dropdown Custom =--LEFT(G2)=1 -- Regards Roger Govier "AHSinVT" wrote in message ... Can Excel find & sort one item in all the cells in a column? My list contains items that I want to assign to one or more categories in a single 'categories' column. If I assign a numeral to each category, then some items will have one numeral and some will have several. Is there a way to enter all the category numbers in ONE CELL for each item, and then make the filter read every entry that has a particular numeral in it (e.g., filtering for numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this filter work like a Word search, and can't figure out how to do it. Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Unable to sort in Excel because of merged cells | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |