software

Assuming I have two columns (category and value), what formula would list all
values in a given category?

Have you tried using the Auto Filter feature?
Select a cell in your data range, and click Data/Filter/Auto Filter.
This will attach little drop down arrows to the header rows of your
data.
Then use the drop down to filter your data.
hth
ScottO

quot;dmz_asdfquot; gt; wrote in message
...
| Assuming I have two columns (category and value), what formula
would list all
| values in a given category?
Thank you. However, I need a forumla that I can enter into a cell. The
formula would be in a cell following each category instance; I can enter this
manually.

quot;ScottOquot; wrote:

gt; Have you tried using the Auto Filter feature?
gt; Select a cell in your data range, and click Data/Filter/Auto Filter.
gt; This will attach little drop down arrows to the header rows of your
gt; data.
gt; Then use the drop down to filter your data.
gt; hth
gt; ScottO
gt;
gt; quot;dmz_asdfquot; gt; wrote in message
gt; ...
gt; | Assuming I have two columns (category and value), what formula
gt; would list all
gt; | values in a given category?
gt;
gt;
gt;

I'm sorry, I struggling to interpret what you want.
Your OP said that you want to quot;list all values in a given categoryquot;,
so I thought that you would have multiple rows with the same
category, and wanted to see a list of all of the associated values.
The Auto Filter would do that , but (if I'm reading right) you want a
formula that in a single cell shows a list of all of the values
associated with a particular category. Is that right, or am I more
confused than I think I am?
S
quot;dmz_asdfquot; gt; wrote in message
...
| Thank you. However, I need a forumla that I can enter into a cell.
The
| formula would be in a cell following each category instance; I can
enter this
| manually.
|
| quot;ScottOquot; wrote:
|
| gt; Have you tried using the Auto Filter feature?
| gt; Select a cell in your data range, and click Data/Filter/Auto
Filter.
| gt; This will attach little drop down arrows to the header rows of
your
| gt; data.
| gt; Then use the drop down to filter your data.
| gt; hth
| gt; ScottO
| gt;
| gt; quot;dmz_asdfquot; gt; wrote in message
| gt; ...
| gt; | Assuming I have two columns (category and value), what formula
| gt; would list all
| gt; | values in a given category?
| gt;
| gt;
| gt;
Sorry. The question and answer (VB code) are at
www.ozgrid.com/forum/showthread.php?t=25239. I would prefer to not use
VB, but at least I have something that works.

quot;ScottOquot; wrote:

gt; I'm sorry, I struggling to interpret what you want.
gt; Your OP said that you want to quot;list all values in a given categoryquot;,
gt; so I thought that you would have multiple rows with the same
gt; category, and wanted to see a list of all of the associated values.
gt; The Auto Filter would do that , but (if I'm reading right) you want a
gt; formula that in a single cell shows a list of all of the values
gt; associated with a particular category. Is that right, or am I more
gt; confused than I think I am?
gt; S
gt; quot;dmz_asdfquot; gt; wrote in message
gt; ...
gt; | Thank you. However, I need a forumla that I can enter into a cell.
gt; The
gt; | formula would be in a cell following each category instance; I can
gt; enter this
gt; | manually.
gt; |
gt; | quot;ScottOquot; wrote:
gt; |
gt; | gt; Have you tried using the Auto Filter feature?
gt; | gt; Select a cell in your data range, and click Data/Filter/Auto
gt; Filter.
gt; | gt; This will attach little drop down arrows to the header rows of
gt; your
gt; | gt; data.
gt; | gt; Then use the drop down to filter your data.
gt; | gt; hth
gt; | gt; ScottO
gt; | gt;
gt; | gt; quot;dmz_asdfquot; gt; wrote in message
gt; | gt; ...
gt; | gt; | Assuming I have two columns (category and value), what formula
gt; | gt; would list all
gt; | gt; | values in a given category?
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;