Removing Duplicates Rows - Based off of 2 column values

[KB13]

Hi,

Hoping someone can help.

I have a large spreadsheet with a lot of data.

I have used concatenate to identify which rows are duplicates.
I am looking for a script that will go down column BE checking for duplicates, once a duplicate is found column H needs to be checked and the lowest value row deleted.

So BE11 & BE12 have a duplicate value, H11 value is 169014 & H12 value is 169017. So row 11 would need to be deleted.

Work sheet is called ‘This Month’ if that also helps for the code.

Hope this makes sense, please let me know if any questions. Appreciate anyone’s time to help on this.

Thanks

 

[LazyBug]

Hello & Welcome to Board!

Try this:
1. Select your table with headres (be sure to include columns H and BE).
2. Ctrl-Shift-L (to toggle Autofilter).
3. Press small filter icon in the column H header, choose Sort Descending.
4. On the Data tab press Remove Duplicates, In the Remove Duplicates window press Unselect All button and then check one column BE only.
5. Press OK.

An important disadvantage of this method: if the value in column H matches, e.g. H11 = H12, row 11 will still be deleted.

Hope this helps your case.