List Bus Routes
I need a unique list of all bus route numbers active this school year.
=UNIQUE(A2:A10) How it works: The UNIQUE function is designed to extract only the distinct values from a specified range. By applying `=UNIQUE(A2:A10)` to the column containing bus route numbers, it efficiently filters out all duplicate entries, providing a clean, non-redundant list of every active bus route. This is invaluable for quick overviews, reporting, and ensuring no route is missed or double-counted.
Data Setup
| Bus Route | Date | Driver Name |
|---|---|---|
| R101 | 2023-09-01 | John Doe |
| R102 | 2023-09-01 | Jane Smith |
| R101 | 2023-09-02 | John Doe |
| R103 | 2023-09-02 | Peter Jones |
| R102 | 2023-09-03 | Jane Smith |
| R104 | 2023-09-03 | Alice Brown |
| R101 | 2023-09-04 | John Doe |
| R105 | 2023-09-04 | Bob White |
| R103 | 2023-09-05 | Peter Jones |
Step-by-Step Guide
Open your Excel spreadsheet containing the bus route data.
Identify the column that contains the bus route numbers (e.g., Column A).
Select the cell where you want the unique list to begin (e.g., C1).
Type the formula `=UNIQUE(A2:A10)` into the selected cell. Adjust the range `A2:A10` to encompass all your bus route data, excluding the header.
Press Enter. Excel will automatically spill the unique list of bus routes into the adjacent cells below your selected cell.