Once you have selected the range, check the top of the screen and click the data tab. It hid all the rows that had b as empty, even rows that had a unique A column entry. Click on the data tab at the top of the screen. Click on the Unselect All button, to uncheck all the checkboxes under вЂColumnsвЂ™. If your selection in step 1 included column headers, then make sure the вЂ My data has headers вЂ™ checkbox is checked. This will open the Remove Duplicates dialog box. If I run the filter a second time, no change. From the Data tab, under the Data Tools group select the Remove Duplicates button. If I use this filter (i understand how filters work, not getting into that here) it will hide either row 2 or 3, but not both. Hey, just tried doing this, and I noticed if I have 3 entries that are identical, this process will remove the ones where the ENTIRE row is identical, but not when the values of the column are identical.

only the rows with the latest product prices will be kept Check the box for My Data Has Headers, if applicable. In the Remove Duplicates dialog box, select the column(s) where you want to remove duplicates. (note: I did figure a way out that works, you can skip to the end to see how) On the Excel Ribbons Data tab, click Remove Duplicates.

Excel remove duplicate rows