Forum

Notifications
Clear all

What's the alternative formula for the SEQUENCE function in Excel 2019?

4 Posts
4 Users
0 Reactions
694 Views
(@jasondawi)
Posts: 1
New Member
Topic starter
 

Hi I'm Jason. I'm a basic user of Excel, but the work I do demands I get better at this program. This is my first post and I'm happy I have a group of people to talk to about this. Figuring out formulas in Excel has me losing track of time, forgetting to eat, sleep, and whatever. Man, this is a journey! 

So, anyway, I need some help creating a formula. Really just one. My goal is to have my first dashboard look exactly like the one Mynda created in her Project Management Dashboard course only I'm using mine for Development. I want to know an alternative formula in Office 2019 for the SEQUENCE formula in Office 365. I'm using a PC. 

 
Posted : 21/07/2022 10:41 pm
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

Hello,

If you search the Internet for ”alternatives to dynamic array functions” you will get some useful sites to check out.

Br,
Anders

 
Posted : 23/07/2022 4:49 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Jason,

On the page where you can download the project management dashboard, there is an option to download the non-365 version which contains the alternative to SEQUENCE.

Mynda

 
Posted : 24/07/2022 8:22 pm
(@jasonreddock)
Posts: 1
New Member
 

Thank you! 

 
Posted : 30/07/2022 10:11 pm
Share: