Excel common attribute list
 

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

Excel common attribute list
 

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

Excel common attribute list
 

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

"kiteboy" skrev i meddelelsen
...
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