I spent the past few hours attempting to figure this out, but VLOOKUP doesn't seem to be the solution, nor does INDEX, so I'm reaching out for help, and would greatly appreciate any assistance that can be offered:
As an example, I've included an attachment.
I have a list of individuals in column A and a list of traits in columns B through F, at least one of these traits applying to each individual.
I wonder if it is possible to list somewhere in the workbook (on the same sheet or not, no preference) of the names that have an 'x' for each respective trait without having blanks where this isn't a match. So, for instance, for 'Male', i would like "Homer, Bart, SantasLittleHelper, Barney, Moe" to list either under that heading or somewhere else under a 'Male' headling.
I thought initially to simply use =IF(B2="x",A2,"") and copy down and over, but then I would end up with a lot of blank lines, which I would like to avoid. (Alternately, if there's a way to take those =IF results and eliminate the spaces to get a fluid list, that would work too).
I then tried =CONCATENATE(IF(B2="x",A2,""),CHAR(10),IF(B3="x",A3,""),CHAR(10) ... in a set of merged, text-wrapped rows in each column, but that didn't seem to be the most efficient way.
Any help, again, would be greatly appreciated--I really want to learn the trick to this if it exists.
Thank you!
Bookmarks