List Unique Tools Checked Out
I need to see a list of unique tool types currently checked out to ensure we have stock.
=UNIQUE(B2:B7) How it works: The UNIQUE function scans the specified range (B2:B7) and extracts every distinct value, presenting them as a dynamic array. This allows the Inventory Manager to quickly see all different types of tools currently checked out without duplicates, making it easier to assess stock levels and plan for reordering.
Data Setup
| Tool ID | Tool Type | Status |
|---|---|---|
| T001 | Hammer | Checked Out |
| T002 | Screwdriver | Checked Out |
| T003 | Wrench | Checked Out |
| T004 | Hammer | Checked Out |
| T005 | Drill | Checked Out |
| T006 | Screwdriver | Checked Out |
Step-by-Step Guide
Identify the column containing the tool types that are currently checked out (e.g., 'Tool Type' in column B).
Select an empty cell where you want the unique list to appear.
Enter the formula `=UNIQUE(B2:B7)` (adjust the range `B2:B7` to match your actual data containing the checked-out tool types).
Press Enter. Excel will automatically spill the unique list of tool types into adjacent cells.
Explore More
Identifying Supplier Contact Persons
As an Inventory Manager, I frequently need to contact suppliers regarding stock levels, new orders, or delivery issues. I have a list of suppliers with their unique IDs, but often need to quickly find the specific contact person for a given supplier (e.g., from cell E2). Manually searching through a large supplier list is inefficient and can delay critical communications.
Extracting All Details for a Specific Item
An Inventory Manager needs to quickly retrieve all associated details (Description, Quantity, Location) for a specific Item ID. Manually copying and pasting multiple cells for each item is tedious and error-prone, especially when managing a large catalog.
Find Stock Level by SKU
I need to look up the current stock quantity for a specific product SKU from a large inventory table.
Categorize Products by SKU Prefix
I need to extract the first 2 letters of an SKU (e.g., 'FU' from 'FU-101') to determine the product category (Furniture).