I have a excel sheet which contains duplicate rows
I want to remove a row if its A C D E F columns are same (Ignore B while calculating duplicates but remove it while removing a row)
At the moment it ignores B while comparison as well as deletion.
Excel – How to remove duplicate rows based on some columns
deduplicationmicrosoft excel
Related Solutions
Here is your answer, it work for me
The trick is to sort your table before using Remove duplicates. Excel always keeps the first data set of a duplicated row. All consecutive rows are removed.
In your case:
Set up a helper column and fill it with numerical values. Start by 1 and use autofill till the end of our table
Make sure your date column is formatted as date and Excel recognize them as date. Otherwise your sorting wouldn't work
Choose
Custom sort(depends on your Excel version). Sort your whole table by date column from Newest to Oldest. That's the important part
Use
Remove duplicatesand select only your Number column which holds your criteria to check for duplicates. Deselect all other columns
Choose
Custom Sortagain and sort your table by that Helper column we have added at the beginning to get your original row order back
Best Answer
In Excel 2013
Done