Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple corresponding values in excel | Excel Worksheet Functions | |||
Asking Excel Solver to use binaries, but selects other values | Excel Discussion (Misc queries) | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) |