Identifying the latest entry for a subset doesn't have to be difficult - use a pivot table. The simple sheet below tracks units sold by personnel and date.