UNIQUE / Staffing Coordinator

List Agencies Used This Month

I need to extract a unique list of temporary staffing agencies we utilized in October.

formula.xlsx
=UNIQUE(C2:C10)

How it works: The `UNIQUE` function is perfect for this task as it extracts all distinct values from a specified range. By applying it to the 'Staffing Agency' column, you instantly get a clean list of every agency used without any duplicates, making it easy to review and report.

Data Setup

Date Candidate Name Staffing Agency
10/1/2023 John Doe Agency A
10/2/2023 Jane Smith Agency B
10/3/2023 Peter Jones Agency A
10/4/2023 Sarah Lee Agency C
10/5/2023 Mike Brown Agency B
10/6/2023 Emily White Agency D
10/7/2023 David Green Agency A
10/8/2024 Olivia Black Agency C
10/9/2024 Chris Blue Agency E

Step-by-Step Guide

1

Open your Excel spreadsheet containing the staffing agency data.

2

Identify the column that lists the 'Staffing Agency' names (e.g., Column C).

3

Select an empty cell where you want the unique list of agencies to appear (e.g., E2).

4

Type the formula `=UNIQUE(` into the selected cell.

5

Select the range of cells containing the agency names, excluding the header (e.g., `C2:C10`).

6

Close the parenthesis `)` and press Enter. The unique list of agencies will automatically spill into the cells below.