Duplicate Column

Help
1

Hello,

Can you please help me? I want to identify if the Column C and Column K is a duplicate by highlighting the those who are duplicate.

Thank you!

DetermineDuplicate.xlsx (9.3 KB)

2

You have to try these steps -

Use Read Range Activity, to read the Column C.
Loop thru the data table -

  1. Take one value at a time, and assign the searchString to "No. " + valuefromDataTable
  2. Use Lookup range activity to find the row where the value is found.
  3. Use set range color to set the color (if found)

Regards,
Karthik Byggari