Hello,
I have looked but cannot find a macro that will find duplicates in column A, then of these duplicates delete the row(s) leaving one row where column B is the smallest integer.
Sample data:
Column A Column B
abc@gmail.com 1
def@gmail.com 18
dflkj@gmail.com 12
abc@gmail.com 9
abc@gmail.com 5
The macro would need to delete rows 4 and 5.
Thanks in advance!