I have a spreadsheet with 1,400 rows and there is a column for customer and invoice number ect. I need to locate all the duplicate invoice number on this spreadsheet and remove them from the file. Is there a Vlookup I can do you identify these dups without going through the whole file and removing one by one. Thanks,
Highlight the data table, go to the Data tab, click on Remove Duplicates under Data Tools, uncheck all columns except for the Invoice Number column, click OK.
