The same pickup ID can appear twice legitimately. For a sample, list K17 / Sat 09:00 / North desk twice, and K17 / Sun 09:00 / North desk once. Put the field names in row 1.

Select the fields that together define a record

Work in a copy. Select A1:C4 in Ulet and choose Data → Remove Duplicates. Keep My data has headers checked. The command compares the selected columns together, ignoring case. Review case-sensitive IDs separately if they matter to your records.

Two Saturday records share K17, 09:00 and North desk. The Sunday record differs by time slot.

Illustrated comparison across all selected columns.

Match the survivors back to the original

Expect one Saturday row and one Sunday row with the original point. Confirm the heading remains and that any related notes outside the selected block still match their records. Reconcile all three fields before replacing the source file.

After removing one repeat, both the Saturday and Sunday bookings remain.

Illustrated before-and-after check for the selected block.

Related Microsoft Excel reference