software

Can Excel find amp; 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?
Hi

With your dropdown for the filter in say column G, with a header in row
1, select the dropdown gt;Customgt;
=--LEFT(G2)=1

--
Regards

Roger Govierquot;AHSinVTquot; gt; wrote in message
...
gt; Can Excel find amp; sort one item in all the cells in a column? My list
gt; contains items that I want to assign to one or more categories in a
gt; single
gt; 'categories' column. If I assign a numeral to each category, then
gt; some items
gt; will have one numeral and some will have several. Is there a way to
gt; enter
gt; all the category numbers in ONE CELL for each item, and then make the
gt; filter
gt; read every entry that has a particular numeral in it (e.g., filtering
gt; for
gt; numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this
gt; filter
gt; work like a Word search, and can't figure out how to do it. Ideas?
gt;
gt;
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.

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; With your dropdown for the filter in say column G, with a header in row
gt; 1, select the dropdown gt;Customgt;
gt; =--LEFT(G2)=1
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;AHSinVTquot; gt; wrote in message
gt; ...
gt; gt; Can Excel find amp; sort one item in all the cells in a column? My list
gt; gt; contains items that I want to assign to one or more categories in a
gt; gt; single
gt; gt; 'categories' column. If I assign a numeral to each category, then
gt; gt; some items
gt; gt; will have one numeral and some will have several. Is there a way to
gt; gt; enter
gt; gt; all the category numbers in ONE CELL for each item, and then make the
gt; gt; filter
gt; gt; read every entry that has a particular numeral in it (e.g., filtering
gt; gt; for
gt; gt; numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this
gt; gt; filter
gt; gt; work like a Word search, and can't figure out how to do it. Ideas?
gt; gt;
gt; gt;
gt;
gt;
gt;

Apply datagt;filtergt;autofilter, since you mentioned filter Roger assumed that
you already had it applied

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;AHSinVTquot; gt; wrote in message
...
gt; I'm missing something here. What is the 'dropdown for the filter'? I
gt; can't
gt; seem to do anything that gives me a 'custom' option. Newbie at this.
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; With your dropdown for the filter in say column G, with a header in row
gt;gt; 1, select the dropdown gt;Customgt;
gt;gt; =--LEFT(G2)=1
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;AHSinVTquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Can Excel find amp; sort one item in all the cells in a column? My list
gt;gt; gt; contains items that I want to assign to one or more categories in a
gt;gt; gt; single
gt;gt; gt; 'categories' column. If I assign a numeral to each category, then
gt;gt; gt; some items
gt;gt; gt; will have one numeral and some will have several. Is there a way to
gt;gt; gt; enter
gt;gt; gt; all the category numbers in ONE CELL for each item, and then make the
gt;gt; gt; filter
gt;gt; gt; read every entry that has a particular numeral in it (e.g., filtering
gt;gt; gt; for
gt;gt; gt; numeral 1 would find 12, 13, 134, 1, etc)? I'm trying to make this
gt;gt; gt; filter
gt;gt; gt; work like a Word search, and can't figure out how to do it. Ideas?
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;