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.

The two A-14 records are selected from a log that also contains A-29.

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.

A-99 has no dated entry and receives a clear message.

Illustrated missing-record check. Keep unknown IDs visible.

Microsoft’s MAXIFS function reference