You could use an Advanced Filter to extract names with a specific
attribute, and update the lists by running the Advanced Filter again,
manually or programmatically.

Another approach would be to list one attribute per row, e.g.:
Banks MI
Banks RI
Banks OF

Then, create a pivot table with Attribute and Name in the row area, and
count of Name in the data area. There's information on pivot tables in
Excel's Help, and he

http://www.contextures.com/xlPivot01.html



ebt wrote:
I am having trouble coming up with a way to do this, any help would be
greatly appreciated:

I have a list of 500 names in column A, in column B I have a series of
attributes (text values, which are separated by commas). In column C
I'd like to take the dozen or so individuals with a specific attribute
listed in column B and list them from C2:C13 (I am only finding
functions that would list these names in the same row they appear in
column A).


Example of how I want this to look (actual doc includes a column for
each attribute):

Names Attributes MI RI
Banks MI, RI, OF Banks Banks
Davis C Smith Jones
Jones RI Walsh Smith
Smith MI, RI, C
Thomas C
Walsh MI




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html