Identify duplicates in more than four columns


Please help me to identify the duplicates when I have a spreadsheet with more than 4 columns. I am using Excel 365.See the example below.

Concatenate or textjoin in conjunction with countifs will not do the trick.

Help will be much appreciated

How to identify and then indicate duplicate value

Name Task 1 Task 2 Task 3 Task 4 Task 5

John    edc      jkl       yui       tgb        asd      

Peter   iop       qwe     cvb      yhn       sdf      

Bill       dfg       wer      zxc      ujm       yui     yui duplicated John Task 3 - Bill Task 5

Kobus  fgh       ert        xcv      ikl          tal      

Koos    ghj        iop       pur      plm        qaz   iop duplicated Peter Task1 - Koos Task  2

Jan       hjk       tyu       vbn       okn        wsx      

Help will be appreciated



send me file or mail me
beepetark Jan 31, '20 at 7:13 am
Add to Discussion



You will find a very nice solution to your problem, painstakingly explained, at this link.


Answer the Question

You must create an account to use the forum. Create an Account or Login