Excel common attribute list

[kiteboy]

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?

 

[Gary''s Student]

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

 

[Per Jessen]

Hi

Select the column containing the attributes, then goto Data > Filter >
AutoFilter.

Select the attribute that you want use as cirteria in the drop down field.

Regards,
Per