Hello all, I want to figure out how to have one cell that can concatenate all values that are equal to a column header above. Hard to explain accurately but here is a picture of a sample workbook. Imgur: The most awesome images on the Internet
The data is setup in a certain way so I want to account for that. I want to search the entire column B for a pre-specified set of rows (I have identified them here as Item1, Item2, etc.). I want a concise or at least simple to follow formula that can comb through Column B and concatenate all responses that match the column headers in D4-G4.
Formula I thought would work: =CONCATENATE(IF({B4,B8,B11,B12,B17,B18,B19,B20,B21}=D4,{B4,B8,B11,B12,B17,B18,B19,B20,B21},"")
I want to be able to change the list B4,B8,B11,etc. to look for the specific items I want in the list that aren't contiguous but the D4-G4 would remain in place and the formula should be right above D4-G4 if that matters since there is a bunch of other stuff below it.
Appreciate any help!
The data is setup in a certain way so I want to account for that. I want to search the entire column B for a pre-specified set of rows (I have identified them here as Item1, Item2, etc.). I want a concise or at least simple to follow formula that can comb through Column B and concatenate all responses that match the column headers in D4-G4.
Formula I thought would work: =CONCATENATE(IF({B4,B8,B11,B12,B17,B18,B19,B20,B21}=D4,{B4,B8,B11,B12,B17,B18,B19,B20,B21},"")
I want to be able to change the list B4,B8,B11,etc. to look for the specific items I want in the list that aren't contiguous but the D4-G4 would remain in place and the formula should be right above D4-G4 if that matters since there is a bunch of other stuff below it.
Appreciate any help!