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?