How do I select all values within a category in Excel?
 

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

How do I select all values within a category in Excel?
 

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

"dmz_asdf" wrote in message
...
| Assuming I have two columns (category and value), what formula
would list all
| values in a given category?

How do I select all values within a category in Excel?
 

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.

"ScottO" wrote:

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

"dmz_asdf" wrote in message
...
| Assuming I have two columns (category and value), what formula
would list all
| values in a given category?

How do I select all values within a category in Excel?
 

I'm sorry, I struggling to interpret what you want.
Your OP said that you want to "list all values in a given category",
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
"dmz_asdf" 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.
|
| "ScottO" wrote:
|
| 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
|
| "dmz_asdf" wrote in message
| ...
| | Assuming I have two columns (category and value), what formula
| would list all
| | values in a given category?
|
|
|

How do I select all values within a category in Excel?
 

Sorry. The question and answer (VB code) are at
http://www.ozgrid.com/forum/showthread.php?t=25239. I would prefer to not use
VB, but at least I have something that works.

"ScottO" wrote:

I'm sorry, I struggling to interpret what you want.
Your OP said that you want to "list all values in a given category",
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
"dmz_asdf" 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.
|
| "ScottO" wrote:
|
| 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
|
| "dmz_asdf" wrote in message
| ...
| | Assuming I have two columns (category and value), what formula
| would list all
| | values in a given category?
|
|
|