Excel common attribute list

  • Thread starter Thread starter kiteboy
  • Start date Start date
K

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?
 
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
 
Back
Top