Alternative SEQUENCE Function for all Excel Version

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!

[QFamilia]

Nowadays I'm working on Excel so your videos are so helpful for me

[JesseYang-zr]

Can you create a dynamic calender using this formula instead of SEQUENCE? Cuz I have 2019 Excel and it doesn't support SEQUENCE. If there's a way to create one, please let me know. Thanks!