See attached. You'll need a very recent version of Excel for these functions to work. There are two formulas.
=UNIQUE(B2:B21) produces a list of unique customer names
gets the most recent (MAX) order date & time and then matches that against products ordered by that customer.