Hi,

I have an excel sheet with data from Column 'A' to 'S'.

I want to identify duplicate entries in Column 'J' and from those identified columns I want to further search Column 'K', highlight the matching text and then fill text in Column 'L' should have the missing data after matching the 'A' and 'K' cells.excel_duplicate_enteries.png

Regards,
~Deep