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?