You can set up your name and date list as a VLOOKUP table, and sort it
decending on the date column, then assuming your list was in A and B, you
could type a name in C1 and put this in D1

=VLOOKUP(C1,NameDateRange,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"Woodkat" wrote in message
...
Each customer (column A) on my list has multiple dates of service(column
B).
How can I sort to only show the most recent date of service?