I have an excel file with two sheets. The first sheet contains raw data received from barcode readers at my factory workshop. The second sheet is where I want to prepare a report using the data in the first sheet.
Each product is scanned at every station it passes through. So in the raw data, each product will be mentioned multiple times depending on how many stations it had to go to. What i want to do is calculate the total area produced, but in this calculation I cannot just use "sum", because then I will be adding the area of the products maybe twice or three times depending on how many times the product was repeated in the data. So I want to add the area of each product without repeating it again.
I know it sounds simple and confusing at the same time, thats why I have add a sample to make my case clear.
Awaiting your kind assistance.
Bookmarks