Hi All,
How to remove duplicate rows in excel.
QTY and USOC is different for each row, so these are not duplicates. If you only want to remove duplicates regarding the two columns you’ve highlighted, you’ll have to write rules on which of the records you want to keep. or if you don’t need some of the data from the Excel sheet, you can keep only the columns you need.