Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
215
Views
Topic starter
When using sequence formula =_xlfn.SEQUENCE(1,26,MIN(Table1[Start Date])+Workings!P2,1) in project mgt dashboard , as it showing error and reflecting array error.
Posted : 03/07/2020 9:56 am
Hi Farooq,
Welcome to our forum! That error means you have a version of Excel that doesn't have the SEQUENCE function. In the YouTube video description it says:
For those who don't have the SEQUENCE function, you can use two formulas instead:
Cell K5: =MIN( start date column ) + output of form control
Cell L5: =K5+1 Copy L5 across columns as far as required.
I hope that points you in the right direction.
Mynda
Posted : 03/07/2020 7:11 pm
