Anbuselvam K
Member
Hi
The below snapshot Column A to L is the base data. The right side P column is the Input and the Q column values are the expected results.
Example
Column C RM1 used in rows 8, 11, and 15 the product is 3, 6 10
Column J RM8 used in row 11 and 15 the product is 6 and 10
Likewise, I have manually filled the first finding products in the expected results.
I need formulas to find the same and fill the all used product names to be displayed as below.
RM1 ==> Product 3, Product 6, Product 10
RM5 ==> Product 6, Product 10
The below snapshot Column A to L is the base data. The right side P column is the Input and the Q column values are the expected results.
Example
Column C RM1 used in rows 8, 11, and 15 the product is 3, 6 10
Column J RM8 used in row 11 and 15 the product is 6 and 10
Likewise, I have manually filled the first finding products in the expected results.
I need formulas to find the same and fill the all used product names to be displayed as below.
RM1 ==> Product 3, Product 6, Product 10
RM5 ==> Product 6, Product 10