Forum

Hi Ben, Probably, but difficult to visualise without a sample Excel file. Mynda

Hi Saliha, You're getting an error because you don't have Microsoft 365. Excel 2016 doesn't have these functions. I don't know of an easy way t...

Hi Keith, It's not clear where the error is occurring, but presumably it's the "Filtered Rows3" step. The error is telling you that you're trying t...

Hi Pieter, I've emailed my MVP contacts to ask if anyone has managed to get this to work. I'll let you know. Is the problem still a formula fire...

Hi Jessica, Welcome to our forum! If you want to sort by a custom range you should add another column that classifies the data numerically into ...

Hi Casey, Please provide some sample data that illustrates the problem. This data only has one answer in column G, which I presume is the column th...

Hi Pieter, Maybe you can test it on another PC to see if it's a Mac issue of something wrong with the code. I'd say after all this testing that it'...

Hi Peter, Welcome to our forum! I've moved this post from the public Dashboards & Charts forum to the private Dashboard course members forum. T...

Hi Alon, Welcome to our forum! Please upload a sample file so we don't have to manually recreate your data in order to help you. Thanks, M...

Hi Pieter, Have you tried the technique described in session 7.05 Formula Firewall Errors? Mynda

Hi Marc, You can refer to columns by position as explained here. Mynda

Hi Grace, Did you intend to attach a file? Be sure to click the Start Upload button after selecting your file. Mynda

Hi Christoph, Yes, you need to update. There are new released very month and you should update at this cadence. April 2018 is nearly 2 years old! ...

Hi Denis, You can split the data into two queries, one for buy transactions and one for sell. You then merge them back together as per the example ...

Hi Mark, That's one way. I think you need to change the quarters to state the year before the quarter number otherwise they won't sort properly in ...