Hi - I'm new to this forum although I have used it loads to get help but I am stuck with this one so hope you guys can assist!
I have a table (2 columns) in excel. The first column contains only a letter, the second a list of company names.
I then have to the right of my table a row headed up with letters matching those in column A however, some of the letters need to be grouped so C's are in one column but in another G & I need to be grouped in one list.
I have created a formula that searches column A for letter C and it pulls out all those companies that match and lists them in one column under the header C. However I now need to pull out the same information for column G&I so I need my formula to draw out companies classed G but also I too.
That is where I am stuck. This is my formula...
=IFERROR(INDEX($B:$B,SMALL(IF(ISNUMBER(SEARCH("G",$A:$A)),ROW($A:$A),""),ROW()-1)),"")
How do I add to this to include "I"?
Any help massively appreciated - I have square eyes right now!
Mel
I have a table (2 columns) in excel. The first column contains only a letter, the second a list of company names.
I then have to the right of my table a row headed up with letters matching those in column A however, some of the letters need to be grouped so C's are in one column but in another G & I need to be grouped in one list.
I have created a formula that searches column A for letter C and it pulls out all those companies that match and lists them in one column under the header C. However I now need to pull out the same information for column G&I so I need my formula to draw out companies classed G but also I too.
That is where I am stuck. This is my formula...
=IFERROR(INDEX($B:$B,SMALL(IF(ISNUMBER(SEARCH("G",$A:$A)),ROW($A:$A),""),ROW()-1)),"")
How do I add to this to include "I"?
Any help massively appreciated - I have square eyes right now!
Mel
