group multiple cells
I have the following table:
A B C
RED X HAT
RED X SCARF
BLUE
BLUE
RED X GLOVES
YELLOW
I need a formula that does the following:
If column A = red and column B = X then concatenate cells in column C where
this is true.
The end result has the list of text, in column C where the formula is true,
in 1 single cell.
HAT
GLOVES
SCARF
Thanks
Dave
|