How do I find the latest check-in for each shared piece of equipment?

Use the equipment ID to define each group, and compare dates only within that group. First identify the columns for item ID, check-in date, and the other details you want to keep. Then find the maximum date for each ID and locate every original row matching that ID and date. A single overall latest date would find only the newest check-in across all equipment.

For example, assume IDs are in column A, dates in column B, and notes in column C. If A2 contains the ID to check, this formula returns its latest date:

=MAXIFS($B$2:$B$100,$A$2:$A$100,A2)

Copy it alongside the equipment IDs, using the cell containing each ID as the criterion. MAXIFS is documented for Microsoft 365, Excel 2024, 2021, and 2019. The date range and ID criteria range must have the same shape and size. [S1] The formula returns a date, not the full record.

Filter the original rows, or use a separate result area, to show rows where both the equipment ID matches and the date equals that ID’s maximum. Keep the full matching row so the associated person, note, or other details remain attached to the date.

For example, suppose the log contains these illustrative records:

• EQ-12 — 2025-03-04 — “Returned to shelf”
• EQ-12 — 2025-03-08 — “Checked in after workshop”
• EQ-27 — 2025-03-07 — “Returned to cabinet”

EQ-12’s latest date is 2025-03-08, so its latest record is the second EQ-12 row. EQ-27’s latest date is 2025-03-07. These are example entries, not claims about an actual equipment log.

Treat equal latest dates as a tie, not as proof that one row is newer. MAXIFS returns a maximum date; it does not choose between records sharing that date. [S1] If the records include a consistently recorded time or another agreed ordering field, use it only if your team considers it reliable. Otherwise, keep both rows visible and mark the tie for review.

Review missing dates and IDs separately. A row without a date cannot be ordered by date, and a row without an ID cannot be assigned to an equipment group. Flag these rows for correction rather than guessing. Also inspect apparent variants such as EQ-12 and EQ12; they may not identify the same value in your data. These checks help validate your log; MAXIFS documentation does not prescribe data-cleaning rules. [S1]

Keep the original rows intact, make a list of the equipment IDs you expect to track, and calculate each ID’s maximum date against the original data. For each ID, return all rows matching both that ID and its maximum date so ties stay visible. Review missing or inconsistent values and document unresolved cases instead of selecting a row by guesswork.

A compact output might include these fields: equipment ID, latest date, matching record details, and review status. Use statuses such as “Confirmed,” “Check for tie,” “Missing date,” or “ID needs review.” The result depends on the IDs and dates in the log being suitable for comparison; MAXIFS identifies a maximum by criteria but does not establish that the log is complete or correct. [S1]