Excel Formula Needed. Combining multiple cells to one.

Found 7th Aug 2017
Hi guys,

I need to know a certain formula in excel. I've done a quick browse on Google and nothing fits exactly what I need.

The first (Column A) is the product/grouped SKU (pcpart), the second (Column B) is the unique SKU (pcpart_0001). I need a third column to display ALL of the unique SKUs for that particular grouped SKU.

The formula for Column C, I need would have the logic of: if Column B contains the frist 5 characters as Column A, Column C would copy all of the SKUs of Column B.

I have tried TEXTJOIN, MATCH, etc. Does anybody have an idea on this?

Much appreciated,
Community Updates
1 Comment

The key is "Array Formula" so it doesn't stop at the first match.
Edited by: "cecilmcroberts" 7th Aug 2017
Post a comment

    Top Discussions

    Top Discussions

    Top Merchants