Hi all! I'm having trouble figuring out how to differentiate duplicates serials, using cell formulas.
Link to file: https://1drv.ms/x/s!ArRB1Ah3M1ZqgpkM7iAAPtt5I9FNvg
- For all INSPECT items, (FOR A SERIAL) , a comment will be inserted in the ACTION 2 column ... following the below behaviour...