I have a large excel spreadsheet 500-700k rows. The spreadsheet is pricing on particular skus from different suppliers. I need to identify where skus match, then search those matches for the cheapest price and keep the row with the cheapest sku while deleting the rows containing the remaining matches.
So if column A is sku, column b is price, and column C is a column that indicates the warehouse, I need to find where column A contains the same value, identify which row contains the lowest b value and delete the remaining rows with the same column A value.
I'm a bit in over my head and would appreciate any help. Hope this makes sense.
If it matters I'm using excel 2010. Thank you.