View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bradasley bradasley is offline
external usenet poster
 
Posts: 10
Default 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