The handoff list needs Electrical together and Facilities together, with each group’s earliest deadline first. Use two keys to keep both rules clear.

Make Team the first level

Create ID, Team, and Due date columns. Add F-04 / Facilities / November 12, E-06 / Electrical / November 13, F-09 / Facilities / November 10, and E-07 / Electrical / November 11, using real 2026 dates. Select the whole table and choose Data → Sort → Custom Sort in Ulet. Indicate the headers and set Team ascending, then Due date ascending as the second level.

Team is the first ascending sort level and Due date is second.

Illustrated sort setup. Select the full records and indicate the header row.

Read across the boundary between teams

The order should be E-07, E-06, F-09, F-04. F-09 has the earliest date overall, but Facilities follows Electrical. If F-09 appears first, check the key order. Verify each ID still belongs to its original team and due date.

The saved order is E-07, E-06, F-09, and F-04.

Illustrated group boundary. F-09 remains in Facilities despite its earlier date.

Microsoft’s reference for sorting by more than one column