List Active Subcontractors
I have a list of daily logs and need to extract a unique list of all subcontractor companies working this month.
=UNIQUE(C2:C9) How it works: The UNIQUE function in Excel is designed to return a list of distinct values from a specified range. By applying it to the column containing subcontractor names, it efficiently filters out all duplicate entries, providing a clean, singular list of every subcontractor that has appeared in your daily logs within the selected range. This is invaluable for quick overviews, reporting, or creating contact lists without manual deduplication.
Data Setup
| Date | Project | Subcontractor | Activity |
|---|---|---|---|
| 2023-10-01 | Project Alpha | ABC Builders | Foundation Work |
| 2023-10-01 | Project Beta | XYZ Contractors | Framing |
| 2023-10-02 | Project Alpha | PQR Services | Electrical |
| 2023-10-02 | Project Beta | ABC Builders | Plumbing |
| 2023-10-03 | Project Gamma | XYZ Contractors | Roofing |
| 2023-10-03 | Project Alpha | ABC Builders | Finishing |
| 2023-10-04 | Project Beta | PQR Services | HVAC |
| 2023-10-04 | Project Gamma | LMN Group | Landscaping |
Step-by-Step Guide
Open your daily log spreadsheet in Excel.
Identify the column that contains the names of the subcontractor companies (e.g., Column C).
Select an empty cell where you want the unique list of subcontractors to appear (e.g., cell E2).
Type the formula `=UNIQUE(C2:C9)` into the selected cell, adjusting the range (C2:C9) to cover all subcontractor names in your data, excluding the header.
Press Enter. Excel will automatically populate the unique list of subcontractors starting from the cell you selected.