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.
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.
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.
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.
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.
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.
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.
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.