Detect duplicate classroom assignments in Excel by using COUNTIF to flag cells with multiple occurrences.