I would make a column for each criteria, with the person's name in column A.
Then just put Xs or something in the columns that apply.
Want to see only pretzel eaters?
Use Autofilter:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"AHSinVT" wrote in message
...
How do you sort items (like a mail list) into categories when some of the
items (but not all of them) are in more than one category? E.g., some
rout
for the Red Sox, some drink beer, and some eat pretzels--and some do all
of
these, but some do none. How do I enter the data and then creat a list
that
includes only the pretzel-eaters?