Forum Discussion
Finding duplicate values in 2 different columns ignoring duplicate values in the same column
Thanks for your reaction, this could work: ideally I'm looking for a formula that deletes the complete rows of the values that are not containing duplicate values (see attachment)
With the suggested formula you can sort columns B and C by column C. The result is as shown in attached file. Then you can delete rows with result false in column C. After this the remaining data is the same as shown in columns F and G.
Thank you, I tried it but my original file kept giving me the message that the formula wasn't right, maybe I'm missing something, I included the original data in a test sheet this time. Can you see what's going wrong?
Can you attach an excel file (.xlsx file) where the formula and the returned error message are shown?
I entered data from your original file (8220/BP, ADO1016C-2/C-RS/C, ADO1018C-2/CTPU-BP/C, CLAS2000/B and CLAS3000/B) and it seems to work.
I cannot get it saved, it keeps on giving an error message and then saving is blocked, but I used this formula in the file attached.
=AND(COUNTIF($B$1:$B$21866,B1)>=2,NOT(ISNA(VLOOKUP(B1,$A$1:$A$5,1,FALSE))))
If you import data from csv Power Query could do removing of duplicates naturally.
