It helps detect unexpected duplications in what should be a unique list. Ctrl++ (plus character) is the keyboard shortcut to insert rows or columns. If you have the rows or columns selected, then the following keyboard shortcuts will quickly add or delete all selected rows or columns. Having a Count column can be really useful for other reasons. There are a few ways to quickly delete rows and columns in Excel. Now you can filter by the count column to show only unique (count = 1) values. All three ‘Gabby’ rows are counted together despite the capitalization. In an Excel table the formula can be easier to list does not have to be in alphabetical order or have the duplicates in neighboring rows.Ī little surprisingly the CountIf test is NOT case-sensitive. Where the entries are in column A down to row 26. The solution is to count the number of entries using Countif() For the above example that means removing both rows for Happy and Jumpy. Sometimes you need to remove BOTH entries if there’s any duplication. In this case, it’ll remove the extra rows for Happy and Jumpy – leaving just one row for each. It will ensure that an Excel list/table has only unique values for the column selected. Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. Thanks for joining us! You'll get a welcome message in a few moments.Įxcel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates
