Hi,
I need a formula or macro to identify duplicate rows in column A, then for all rows that contain the same data in column A (could be 4 or 5 lines), I want the whole row deleted based on criteria of what has the lowest value in column F.
Many thanks
The way I am reading this is that you want to keep only one value of the Part and that is the one with the minimum value. This can be done with a pivot table.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks