Hi,
On the attached, 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
Hi CraigR&M,
Here is code that I think does what you describe. Out of any duplicates, the value with the highest corresponding value in Column F is kept.
Hope that helps,
Please Login or Register to view this content.
Dan
Last edited by djbomaha; 11-30-2016 at 07:56 PM. Reason: Error in code
*** Double post deleted ***
Last edited by djbomaha; 11-30-2016 at 07:35 PM. Reason: Double Post
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks