Hello,
Win 10, Office 365
I attached example excel file. ExcelForum1.1.xlsx
Column K-NgType displays machine test results by: component location, its identity number, barcode, and batch data in columns:
F-Batch | G-barcode | H-ID | I-Reference
For the example, I isolated groups by color.
Column N-OperatorNgType contain a final figure according to employee decision.
In each group, there may be one result or more, which is repeated as the number of rows in each group.
I need to isolate / to count only a single value in each group, *as shown in column O-Net Value*
In the beginning I thought of using simple 'Remove Duplicates' with reference to the columns I listed above, but since the data in column K -NgType is important, probably it is not possible.
The Original file contains above 300K rows
Any suggestions?
THANKS
Ornico
Bookmarks