Forum Discussion
Solved
Display entries based on date interval
Hi guys, Need your help with this one. I could not attach the xlsx file here, so I uploaded on wetransfer link: https://we.tl/t-s8sAL5y95g I have two tables: Table A and Table B Table A can h...
=DROP(REDUCE("",SEQUENCE(ROWS(Tabelle7[TASK])),LAMBDA(x,y,VSTACK(x,HSTACK(IFERROR(EXPAND(INDEX(Tabelle7[TASK],y),INDEX(Tabelle7[end date],y)-INDEX(Tabelle7[start date],y)+1),INDEX(Tabelle7[TASK],y)),SEQUENCE(INDEX(D2:D5,y)-INDEX(Tabelle7[start date],y)+1,1,INDEX(Tabelle7[start date],y),1))))),1)
With Office 365 or Excel for the web you can create a dynamic table and apply this formula. In my example the table name is "Tabelle7".
You can use Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
- OliverScheurich Thank you for your answer.
Unfortunately this does not help me because everything needs to be executed automatically. Meaning, no manual refresh can be done.
Do you think that there is a formula that can do this? It would be very helpful to get any suggestions. Many thanks!
