Taylor Gilstrap
asked on
How to delete rows in an Excel spreadsheet with duplicate order numbers, but only when they have the same sequence number
I am trying to create a quick way to automate a very time-consuming task. The issue is that the data will have multiple duplicate order numbers in one column, but are at different sequences within the operations within the plant. I only need to delete the rows that have both duplicate order and sequence numbers. Any idea for a VBA script that could help with this issue?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
You can open the excel , go to the data tab and then click remove duplicates..(middle button..)