Hi Guys,
I have about 20-30 columns with a lot of data, over 800k rows. I have one column that contains a lot of duplicates, call it columnX. I want to remove entire rows if there are duplicates in columnX.
I can highlight the duplicates and filter them but this takes way too long with 800k rows, and also i want to be able to keep one of the rows, and only remove the duplicates.
I cant use the "remove duplicates" button either because this only removes "duplicate rows", not rows that have duplicates in a particular column.
Hope this makes sense and someone is able to help!
thanks in advance.
mike
Bookmarks