Macrogopal1989
New Member
- Joined
- Feb 12, 2019
- Messages
- 1
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 .here the issue is need to copy paste one worker name for the one duplicate combination .
For example :
If the column A contains 3 duplicate value
123
123
123
The column B adjacent of the Cells having duplicate value to be filled from the list of worker name in the sheet 2
Output:
A B
123 Raj
123 Raj
123 Raj
Please help me on this
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 .here the issue is need to copy paste one worker name for the one duplicate combination .
For example :
If the column A contains 3 duplicate value
123
123
123
The column B adjacent of the Cells having duplicate value to be filled from the list of worker name in the sheet 2
Output:
A B
123 Raj
123 Raj
123 Raj
Please help me on this