![]() |
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