Hi All,
I am having two sheets , first sheet contains inventory details of batch number , second sheet contains worker list . I need to do condition formating to get the duplicate values . If the duplicate value found , need to copy paste a worker name to adjacent cell of the duplicate column...