List Rooms Used for Exams
I need a unique list of all classroom numbers assigned for the SAT testing day.
=UNIQUE(B2:B7) How it works: The UNIQUE function takes a range of cells as its argument and returns a list of only the distinct values found within that range. In this scenario, it efficiently extracts each unique classroom number from the full list of assigned rooms, eliminating duplicates and providing the Testing Coordinator with a clean list of all rooms utilized for the SAT testing day.
Data Setup
| Student Name | Room Number |
|---|---|
| Alice | 101 |
| Bob | 102 |
| Charlie | 101 |
| David | 103 |
| Eve | 102 |
| Frank | 101 |
Step-by-Step Guide
Enter your exam schedule data into an Excel sheet, ensuring classroom numbers are in a dedicated column (e.g., Column B).
Select an empty cell where you want the unique list to appear (e.g., D2).
Type the formula `=UNIQUE(B2:B7)` and press Enter.
Excel will automatically spill the unique list of room numbers into the selected cell and the cells below it.