I am trying to get the productivity of machines
data availability
1) Data entry sheet with different products process with machine used and different capacity - start date and end date
2) a separate sheet with each machines capacity per day - for different capacity products
Currently to get what result i wanted - the grey highlighted result (4) by manually first making a unique list of all products
then get total qty using count , vlookup to get the capacity per day for product for the machine
Please refer the attached file. advise any smarter way ! specially avoiding to create any manual list summary etc
data availability
1) Data entry sheet with different products process with machine used and different capacity - start date and end date
2) a separate sheet with each machines capacity per day - for different capacity products
Currently to get what result i wanted - the grey highlighted result (4) by manually first making a unique list of all products
then get total qty using count , vlookup to get the capacity per day for product for the machine
Please refer the attached file. advise any smarter way ! specially avoiding to create any manual list summary etc