Where there are duplicates but the basket size is different what determines which ones you lose, or doesn't it matter?
e.g for John Smith Cherry why do you show the 05 basket and not say the 03 basket record?
Personally I'd use two helper columns and a data filter to show the records you don;t want and delete them - within and by a macro if necessary
e.g. F2 copied down
G2 copied down
Then autofilter column G for values >1. In a macro use the
However this is clearly a much simplified example and doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see.
Bookmarks