Naresh Yadav
Active Member
Respected All,
I need a formula Help that can help me to Multiply the value mentioned post "'-" Sign in first Column (Separate Heading) with the Order Qty
I have atttached the excel file for your kind
I need a formula Help that can help me to Multiply the value mentioned post "'-" Sign in first Column (Separate Heading) with the Order Qty
I have atttached the excel file for your kind
Separate | Order Qty | Expected Result |
1211332-2|1211088-2|1211007-3 | 2 | 1211332-4|1211088-4|1211007-6 |
1211332-4|1211088-4 | 3 | 1211332-12|1211088-12 |
6111085-1|6111089-1|6111077-1|6111081-1 | 5 | 6111085-1|6111089-1|6111077-1|6111081-1 |