How to Use SEQUENCE in Excel to Generate Pass Numbers
Open your Excel event pass workbook (.xlsx) in Cue Office. Use SEQUENCE to generate a column of pass numbers from a count, a starting number, and a step. When you reduce the count, the extra numbers disappear automatically.
How do you generate a number list using count, start, and step?
Create a new spreadsheet in Cue Office and paste the practice data into A1. B2 contains the count, B3 is the starting number, and B4 is the step value (the difference between consecutive numbers). Leave D2 and the cells below it blank for the numbered list.
Click cell D2 and paste the formula below. B2 determines the number of rows, the second parameter 1 restricts the output to one column, B3 sets the start number, and B4 defines the step increment. With values 5, 1201, and 1, cells D2:D6 display 1201 through 1205.
=SEQUENCE(B2,1,B3,B4)
Click Save As in the upper-left toolbar to save this five-number baseline workbook so you can verify it again later.
What happens to existing numbers when you change count, start, or step?
Type 3 in B2. Column D immediately shortens to 1201, 1202, and 1203, while cells D5 and D6 clear automatically.
Keep B2 as 3, change B3 to 1400, and change B4 to 5. The sequence now begins at 1400 and increments by 5, displaying 1400, 1405, and 1410.
If you only want to undo these practice changes, close the working copy without saving them and reopen the workbook you saved earlier. If Cue Office offers to recover the test edits, choose Discard only if you want to drop them. The saved settings are 5, 1201, and 1, and the list still runs from 1201 to 1205.
How do you prompt Cue AI to generate dynamic number lists?
Open a copy of the practice sheet with D2 and the cells below it still blank, then click Cue AI. Tell it which cells hold the three settings and where the list should start.
Create a live, one-column list of event pass numbers under the existing heading, beginning in D2. Use B2 for the number of rows, B3 for the first number, and B4 for the amount to add between numbers. The list should recalculate and resize when any of those settings changes. Edit only D2 and keep the settings and all headings unchanged.
Cue AI wrote a SEQUENCE formula in D2 only. Use Save As to save a copy, then close and reopen it. Check that the settings and headings still match the original sheet and that column D shows 1201 through 1205.
In the reopened copy, change B2, B3, and B4 to 4, 2100, and 10 respectively. Column D shows 2100, 2110, 2120, and 2130. D6, which held the fifth pass number, is now blank.
Practice with Event Pass Parameters
Show the full example
Paste this dataset into A1. Column headers and parameters are preset, leaving D2 open for your sequence formula. Return to formula steps.
Setting Value Pass number Rows 5 Start 1201 Step 1
Verify First Number, Last Number, and Count Before Distribution
For the next batch, give Cue AI the cells that hold the new count, starting number, and step. Before you hand the passes to the distribution desks, count the entries, check the gap between the first two numbers, and verify the last number. If the batch shrinks, check that the old numbers at the end of the list have cleared.
Open the organizer’s pass approval sheet (.pdf) in Cue Office for free and compare the starting number and quantity with your Excel pass list (.xlsx). Record canceled numbers and the number of passes handed over in a Word handoff log (.docx). If several desks are issuing passes, list each desk’s assigned number range in a PowerPoint deck (.pptx). Cue Office offers free spreadsheet, document, and presentation editing.