Hi guys.


I have a problem here. I want to identify the redundant records from thousands of data. Specifically, redundant data means the one that have same Serial Number and Operation Number simultaneously. If the formula can identify them, i want it to keep the data with the latest Finish Execution date , and delete the rest of them. But if the latest date also same, just remove the redundancy. Please refer the attachment and u will get what i mean.

If possible, i prefer the formula to automatically run ( without certain row range) every time i update rows A and B , because i have thousands of data that i need to update everday.


Thanks in advance. Appreciate ur help.redundant forum.xlsx