Like the photo shown, i need to do a homework about summing up product quantity. This formula is bestly based on Excel. It is a $30 project.
In sheet 1,
A column is Order no. (A2 = 0001, A3 = 0002, A4 = 0003..etc). Products are free to order, order 0002 can contains some model where 0003 have.
Start from Y2, product information recorded in below absolute format and repeat till end of the order:
Model Product Qty Price
Model no. are started with "PD-" , "T-" , "Set-" , "A" or "S-", where repeat in every 4 columns. Product full name start with model no.
I need to add a Sheet 2, sum up all the corresponding data in Sheet 1 and sort in below format:
Model Qty Corresponding Order no.
PD-0553 4 0001, 0003
PD-0554 3 0001
Sheet 2 should be in excel2.JPG format.
Eg. For Model PD-0553, there are 2 ppl ordered.
Order no.0001 takes 2 and no.0003 takes 2, so tatally 4pcs need for procurement.