Is Excel SEQUENCE Missing? No Problem! 😎
The SEQUENCE formula creates a list of numbers, starting from a specified number, with an increment you define.
Handy when you need sequential values.
But not all Excel versions have SEQUENCE yet. 😔
Luckily, there's a simple workaround using COLUMN + ROW functions! 🙌
Here's how:
Decide your starting number and increment.✅
Assign those values to 2 cell ranges - say A1 for start, B1 for increment.
In C1, enter: =A1 (The first number is your start number)📌
In C2 and drag down, enter: =C1+B1
(Prior number + the increment)
Resize column C to the length you need.⚡️
That's it! Column C now holds your sequence of numbers, even without SEQUENCE.😎
The SECRET?
COLUMN increases across, by 1 each row.
ROW increases down, by 1 each column.
By adding those functions with your start/increment cells, you emulate SEQUENCE's logic!
Try it now:
A1=5 (Start)
B1=3 (Increment)
C1=A1
C2=C1+B1
C3=C2+B1
COLUMN(A1)+ROW(A1)= 5
COLUMN(A2)+ROW(A2)= 8
COLUMN(A3)+ROW(A3)= 11
You've mimicked:
SEQUENCE(1,3,5) = 5,8,11
Hope this alternative trick helps you create perfect sequences - even in old Excel versions!
