Hi Everyone, I want to remove the duplicate records in an Excel file by comparing the values of 2 columns and only keep unique records,
here is the file now I want to remove Duplicate records from the file where Invoice number and Supplier Number column values are same. Ex. in the pic I want to remove 4th row as row 3 and row 4 have same supplier and invoice number. Rest the data will be kept as it is
Can someone please provide me the query