Home |
Search |
Today's Posts |
#1
|
|||
|
|||
return groups of components
Hi All,
I have a challenging (for me) problem in excel. I have a spreadsheet with names of groups running across (row 2:2) running down column B:B I have names of components. I would like to have a function for each component, returning the groups that the componnent is in. EX: (in my spread sheet the X is actually a number) Group: round animal fruit solid component: apple X X pear X pig X tree rock X So I would like to have a function look across the matrix for apple and have F(apple) return: Round, Fruit Anyhelp or ideas are GREATLY appreciated and thanks so much in advance!! Stan |
#2
|
|||
|
|||
Can this even be done??
Please someone help!! :] "Stan Altshuller" wrote in message ... Hi All, I have a challenging (for me) problem in excel. I have a spreadsheet with names of groups running across (row 2:2) running down column B:B I have names of components. I would like to have a function for each component, returning the groups that the componnent is in. EX: (in my spread sheet the X is actually a number) Group: round animal fruit solid component: apple X X pear X pig X tree rock X So I would like to have a function look across the matrix for apple and have F(apple) return: Round, Fruit Anyhelp or ideas are GREATLY appreciated and thanks so much in advance!! Stan |
#3
|
|||
|
|||
Try this (assuming "apple" is in B4 and "round" is in C2)
In G4 =trim(if(c4="","",c$2)&" "&if(d4="","",d$2)&" "&if(e4="","",e$2)&" "&if(c4="","",e$2)) You might have to change c4="", d4="", etc to something like OR(c4="",c4=0) etc depending on what other thatn a number you might have in the cells that are not "X" in this example On Wed, 20 Apr 2005 10:56:18 -0400, "Stan Altshuller" wrote: Can this even be done?? Please someone help!! :] "Stan Altshuller" wrote in message ... Hi All, I have a challenging (for me) problem in excel. I have a spreadsheet with names of groups running across (row 2:2) running down column B:B I have names of components. I would like to have a function for each component, returning the groups that the componnent is in. EX: (in my spread sheet the X is actually a number) Group: round animal fruit solid component: apple X X pear X pig X tree rock X So I would like to have a function look across the matrix for apple and have F(apple) return: Round, Fruit Anyhelp or ideas are GREATLY appreciated and thanks so much in advance!! Stan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
How do I return dynamic lists? | Excel Worksheet Functions | |||
Return lowest quantity | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |