Hi, I have an excel of say 2 column (Employee id and client ID).
Like the below
I need to highlight the duplicates (where Employee_ID and Client_ID) is duplicated, and write the value as “Duplicate” in the third new column named “Status”. Challenging part is, i need to mark only the duplicate values (should not mark the originals as duplicate).
Like below :
Appreciate any help on this. Tried various methods, but not getting the expected results.
Note : this is part of a big process, so any simple flow would be appreciated.