Hi guys,

I have a spreadsheet which lists all the price changes for the month.
Before doing any updates, I will need to search through the spreadsheet for any duplicates.

If any duplicate rows are found, I need the VBA code to look at the 6th column of those duplicate rows to find out which duplicate row has the lowest value, and delete the rest of the duplicate rows.

For e.g. If there are 4000 rows, and duplicates are found in row 10, 100 and 1000, the code will find that row 100 has the lowest value in the accompanying cell in the 6th column, and delete row 10 and row 1000.

So in the end there will only be 3999 rows left, with no blank rows in between.

I think I would need to use arrays right? I'm still not good with arrays and looking up on it now.

Will appreciate any advice given!