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.

B2, B3, and B4 set to 5, 1201, and 1, with an empty column D under the header
Parameters are placed on the left, leaving D2 open for the list formula.

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)
D2 formula SEQUENCE(B2,1,B3,B4) displaying 1201 through 1205 in column D
Five pass numbers starting at 1201, incremented by 1.

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.

B2 changed to 3, D2:D4 showing 1201, 1202, 1203, and D5:D6 blank
Reducing the count from 5 to 3 automatically clears former numbers 1204 and 1205.

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.

B3 set to 1400 and B4 set to 5, column D displaying 1400, 1405, and 1410
Three passes starting at 1400, increasing by increments of 5.

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.

Original parameters 5, 1201, 1 and the five consecutive numbers restored upon reopening
Reopening the baseline file restores the original sequence 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.

Cue AI button and panel on the left, parameter table and blank list column on the right
Open the Cue AI panel beside the empty pass number column starting at D2.
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.

AI workbook reopened showing D2 formula, five numbers, and intact parameters in B2:B4
Verify the formula in D2 and the numbers 1201 through 1205 after reopening.

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.

Reopened file with parameters updated to 4, 2100, 10 showing numbers 2100, 2110, 2120, 2130
Updating settings dynamically generates four passes starting at 2100 with step 10.

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.

Free Download Cue Office