Asset A-14 was serviced on November 2 and 4. A different asset, A-29, has a November 6 record. Find the latest date for A-14 in the unsorted log.
Filter the maximum by asset ID
Put the three IDs in A2:A4 as A-14, A-29, A-14. Put November 2, 6, and 4, 2026 in B2:B4 as dates. Enter A-14 in D2 and =MAXIFS($B$2:$B$4,$A$2:$A$4,D2) in E2. Format E2 as a date and expect November 4.

Illustrated source scope. The newest date must belong to the selected asset.
Handle an ID without a dated row
For a log whose dates are positive date values or blanks, use this version.
=IF(COUNTIFS($A$2:$A$4,D2,$B$2:$B$4,">0")=0,"No dated entry",MAXIFS($B$2:$B$4,$A$2:$A$4,D2))Test A-99 and expect the message. Restore A-14 and check its two source dates. If two records share the latest date, consult the log for any details that distinguish them.

Illustrated missing-record check. Keep unknown IDs visible.



