Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to match up variables to a common list and confirm | Excel Worksheet Functions | |||
Keep schemaLocation attribute when saving to XML data from Excel | Excel Discussion (Misc queries) | |||
Caption attribute at Cell in Excel XML | Excel Discussion (Misc queries) | |||
How do I change the default attribute in excel? | Excel Discussion (Misc queries) | |||
the attribute "nullable" is not supported in convert excel to xml | Excel Discussion (Misc queries) |