If you sort descending on dates (real numeric dates) it will come up first,
if you meant you want a formula to retrun the latest date

=INDEX(A2:A100,MATCH(MAX(B2:B100),B2:B100,0))

will give the customer with the latest date

Regards,

Peo Sjoblom

"Woodkat" wrote:

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?