How to Use FILTER in Excel to Build a Live List by Status

In Cue Office, open your Excel pickup tracker (.xlsx) and use FILTER to list only the records that match a status such as Ready. The results appear next to the original table and update when you change the status in the selector or in a source record.

How do you generate a separate pickup list by status?

Create a new spreadsheet in Cue Office and paste the practice data into A1. Columns A through C contain the source records, E2 holds the target status Ready, and G1:I1 already has the output headers. Leave empty space below and to the right of G2.

Five pickup records on the left, Ready in E2, and headers only on the right
The left side keeps all pickup records, and the list on the right starts at G2.

Click G2 and paste the formula below. A2:C6 specifies the three columns to return, and C2:C6=E2 compares the status row by row. The third argument, "No pickups", is the text shown in G2 when no records match.

=FILTER(A2:C6,C2:C6=E2,"No pickups")

Enter the formula only in G2. When multiple rows match, their values fill the cells to the right and below G2. This is called spilling. With Ready in E2, the list shows P101 Badge and P103 Keycard. If you add records below row 6, extend both the source range and the status range in the formula.

What should you check when G2 displays #SPILL! or No pickups?

If G2 displays #SPILL!, check the cells where the output should appear. Here, Occupied in H3 blocks the second row of results. If that entry can be removed, click H3 and clear its contents. Both rows appear with the existing formula in G2.

G2 displays #SPILL!, H3 contains Occupied, and E2 is Ready
Occupied in H3 blocks the item cell for the second matching record.
After clearing H3, G2:I3 displays P101 Badge Ready and P103 Keycard Ready
With H3 cleared, P101 and P103 appear in source table order.

Change C3 from Packed to Ready, and P102 will appear between P101 and P103. Next, change E2 to Cancelled. Because the source table has no matching status, G2 displays No pickups and clears the previous result rows.

E2 changed to Cancelled, G2 displays No pickups, and the remaining result area is empty
When there are no Cancelled records, only No pickups remains in G2 on the right.

Change C3 back to Packed and E2 back to Ready. Save and reopen the workbook to verify that only P101 and P103 appear on the right again.

After reopening the manual workbook, E2 is Ready, and P101 and P103 display again
After restoring the practice data and reopening, Ready still filters the original two records.

How do you prompt Cue AI to generate a self-updating list?

Open a copy of the pickup sheet with an empty results area, then click Cue AI. Specify the status to filter by, the fields to return, and where the list should start.

Cue AI button and panel in the upper left, with no output rows below G2 on the right
After opening Cue AI, compare the source table on the left with the output location on the right.
Use the status typed in E2 to build a live pickup list. Return Pickup ID, Item, and Status from A2:C6 for each row whose status equals E2, in source order. Start in G2 below the existing headers. Let the results expand or shrink automatically when E2 or a source status changes. If there are no matching rows, display No pickups. Edit only G2 and leave the source data, selector, and all headers unchanged.

Cue AI writes a single formula into G2. Save and reopen the copy, click G2, and confirm in the formula bar that it filters A2:C6 using the status in E2. Verify that the original table, E2, and the headers remain intact, while the right side displays P101 and P103.

After reopening the AI workbook, E2 is Ready, and the G2 formula along with P101 and P103 are readable
After reopening, the formula bar shows how G2 filters the source data. The two Ready records are still visible on the right.

In the reopened copy, change E2 to Packed, and the right side displays P102 and P105. Then change C6 for P105 to Collected, leaving only P102 in the list.

E2 is Packed, C6 is Collected, and only P102 Cable Packed remains on the right
After updating P105 to Collected, only P102 remains in the Packed list.

Finally, change E2 to Cancelled and confirm that only No pickups appears in G2 on the right.

Practice with five pickup records

Show the full example

Paste the entire block starting in A1. E2 is the status criterion, and the output headers are already in place. Return to formula steps.

Pickup ID	Item	Status		Status to show		Pickup ID	Item	Status
P101	Badge	Ready		Ready
P102	Cable	Packed
P103	Keycard	Ready
P104	Adapter	Collected
P105	Charger	Packed

Review pickups before shift handoff

When handling a new batch of items, provide Cue AI with the record range, criteria cell, and output starting point to rebuild your pickup list for the new sheet. Before handing over your shift, take an item that was just picked up, update its status to Collected in the source table, and confirm that it disappears from the active pickup list. Then check that E2 is set to the status needed for the next shift.

Open the warehouse transfer sheet (.pdf) for free in Cue Office and compare its pickup IDs and item names with the Excel pickup tracker (.xlsx). For items that were transferred and still need a signature, record their IDs and any follow-up in a Word handoff log (.docx). If the next shift has a briefing, list unclaimed items in a PowerPoint deck (.pptx). Cue Office offers free spreadsheet, document, and presentation editing.

Download Cue Office for free