Ok so say I have a spreadsheet like this:
IMAGE1.jpg
And I want Excel to remove the rows where the NBR and CODE are duplicates, but I want the row that remians to be the one with the highest value in the REV column (the ones I highlighted yellow).
Any ideas on how I could accomplish this w/o scrolling and highlighting the highest values in a spreadsheet of thousands of entries?
THANKS IN ADVANCE!!
Let's pretend NBR = A1
D2:
Is is an array formula confirmed with Ctrl+Shift+Enter.
Please Login or Register to view this content.
Copy downwards.
Select D2:D5000, copy, paste values to get rid of formulas.
Filter D. Choose only "2"
Select A2:D5000, go to Cells->Delete Sheet Rows
Unfilter. All nonmax per duplicate lines are gone.
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