Selecting and removing duplicates row with condition
Hi guys, I've searched around the forum however didnt come close to what I wanted to achieve, or maybe I missed out. Anyway, I need help on the table above. As can be seen, I have duplicates as per highlighted by color. The serial number is same for most part because the part is inspected on different section(as show 1A,1B,2A,2B,3A,3B,4A,4B). Usually if the part fails inspection it will be re-insp...