Forum

Hi Raymond, Great to see you're making use of the new dynamic array functions. You should be referencing the spilled results of dynamic array formu...

Hi Pieter, You need to perform a logical test to check if the rows in the UpdateColours table = the 'Old' value in the TextSubs query. If TRUE, the...

Hi Mike, Welcome to our forum! Glad you enjoy my videos There's no built-in way to automatically move the PivotTables closer together as rows b...

Thanks for clarifying. Power Query it is then. 1. Format the data on each sheet in an Excel table (CTRL+T). The tables will be named Table1, Table2...

Thanks for the file. What version of Excel do you have? If you have Microsoft 365 or Office 2021 then you have the new dynamic array functions, which ...

Thanks for the screenshots. The data types for those columns are not set in Power Query. Both are type 'Any'. If you set the data types, do they then ...

Hi Saliha, You can use COUNTIF to add a count of the B/e No records and then use a PivotTable to get your layout. See attached. Mynda

Hi Moriel, As I mentioned, I can't open your queries and you haven't said which columns you've added, but if I look at the tables in Power BI and s...

Hi Jacqui, You can protect the sheet objects (charts, images etc.). By default all objects are locked, you just need to enable the protection on th...

Hi Moriel, I'm not sure what you mean by 'the calculations'? Are you saying in Power Query you can see results in the new columns, but when you clo...

Hmmm, I'm not sure why the data table doesn't follow the order of the series in the PivotTable. I assume it's because of the different chart types, bu...

Hi Erwin, You can manually sort by left clicking and draging the fields names into the locations you want in the PivotTable itself. Mynda

Hi Matt, The XLOOKUP formula finds the CRT to date, plus the average CRT to date * the remaining working days in the month. It's simply extrapolati...

Hi Kate, Welcome to our forum! You're right, you should not have your data in separate sheets for each month. You can use Power Query to gather the...

Hi Riccardo, Riny is expecting you to have used the technique shown in lesson 2.05 of the Power Query course. Have you tried that and then applied ...