Writing duplicates to another column
if I have a data of 10 columns and 12000 rows in which a few columns have few duplicates in certain rows. How can I write another column, in which it says which column has a duplicate entry with respect to that particular row? IN LIBRE CALC, please help me :)
edit: if you look into the "M" column you can see the type of output I need. if I have to find the duplicates that way for thousands of records .i I can't do it manually so I need a generalized formula to show me the output.
please do the neeedful :) C:\fakepath\copy_doc.xlsx
1st half of the file : C:\fakepath\1.xlsx 2nd half : C:\fakepath\2.xlsx
thankyou :)