ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   group multiple cells (https://www.excelbanter.com/excel-worksheet-functions/121101-group-multiple-cells.html)

bradasley

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


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com