Here is Pete’s answer to the recent Music Festival Schedule Challenge.
In this video, see how he used Index/Match functions as well as a helper row to create an easily expandable chart data set.
Here is the sample file:
Thanks Pete! Great and easy solution. I way over complicated it.
this tutorial is absolutely amazing… until you realise that you’re using google excel and therefore can’t use your template.
Any chance you could offer such tuto on google drive’s excel?
Thanks Manon, did you try and upload it already? I ask because it may work for conditional one but not for the chart one.