Consider using AutoFilter. You can set separate criteria on each attribute
and only display the rows where the criteria are satisfied. See:

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


--
Gary''s Student - gsnu200781


"kiteboy" wrote:

Hi,
If you have a long list of items in a column and attributes in seperate
columns for each of the items in the list, how can you select the items from
the list with the common attributes? Or say this is a list of people and one
of the attributes is hair color, how can you write a formula to list the
names of all the people with brown hair, but only if they have brown hair?
--
kiteboy