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