Find recent value by date

Hi, I am in trouble please help me. I have attached workbook for your reference. I have 4 columns that are A, B, C, D, E, and F. Columns A contain customer number (ID), Column B, C, D, E contains order details & column F contains order details. I need to find out which customer place order twice & take recent order. I know I can do it via auto filter or sorting data but when data is huge that time it’s hectic job. I would like to automate this. Some times what happens customer place 5 to 10 orders in & I need to take recent one. When I find recent order that time I delete old orders row. I need to this task very carefully because its customers orders. Request you to please advice on this.