One Main box (carton box) will have One Main barcode (master barcode) placed outside of it. Inside of the box will be 6 to 18 barcodes which represent the Main outside barcode.
Inside barcodes could be all different OR
combination of few of the same barcode plus some individual barcodes OR
all of the barcode can be the same. Please view the below examples
Now, first we will scan the Main outside Barcode of a box and then we will scan all the inside barcode, system need to do a comparison of the scanned main barcode to MAIN BARCODE coulman and then compare all the scanned inside barcode and show the result. If all barcode of the main barcode all are different then the task is easy, however if there are multiple of the sam barcode in the box then system must count them againt the sacnned items (Example if you have 2 of the same barcode and the 3 of another barcode system should show 2 for one of the barcode and then 3 for the other and then compare to the scanned barcodes (barcodes of the inner box will be scanned individually) (please view an example to right side). Logic is that, when we scan the Main Barcode the system will look into the database and then compare all the box inner scan to data base and show the result as good or error.
Please view the attached file. I also need this by August 3, 2016.
Because of short time, I need some expert at excel to do this correctly the first time.