Forum Discussion

PowerLord's avatar
PowerLord
Copper Contributor
Mar 27, 2021
Solved

Trouble with Getting Data using Indirect from varying rows

I am going bonkers trying to set excel-up as per my requirements.  I have attached my excel file here which is Office 365 version, Windows 10.  My problems are: 1.) in the summary sheet, under Techn...
  • chahine's avatar
    chahine
    Mar 29, 2021

    There was some issue with links, so i turned it off

    and it worked

    so i did this dynamic charts, using sequence which uses ur first & last date in time frame & index & indirect, have a look at the sheet charts

     

    in summary, i used just index, & last date from your time frame

Resources