How to return the last time value in Excel Once working through the functions to return the earliest call and the client making that call, doing the same for the day’s last call is simple.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.