I searched around the forum quite a bit and was not able to piece together my answer, or find someone with a similar objective in any other thread.

I have a worksheet with duplicates in column A, with often different prices in column D.

What I'd like to do is find a formula that removes all duplicates except the one that has the lowest price in column D. If duplicates have the same price in column D the one with the lowest number in column E should be removed.

Thanks in advance for any help!