Forum

Hi Pete, The SPILL error occurs when you have data in cells that the dynamic array formula wants to spill the results to. Delete the data occupying...

Hi Doug, You need to use the 'regular chart from a PivotTable' technique to fix a colour to a Slicer item. Mynda

Hi Nick, Welcome to our forum. Please upload your file so we can see where you're running into trouble. Mynda

Hi Karim, You need to add a date dimension table that contains a list of consecutive dates for the whole year. Then create relationships between th...

Hi Kaspars, You need to change your update channel from semi-annual to monthly to get the XLOOKUP function. Speak to your IT people to make that ha...

Wow, great to hear, Dave!

Hi Doug, No files were attached. Please upload again and be sure to click the 'Start Upload' button after selecting your file. Mynda

Hi Kaspars, You can change the formula in cell H3 to this: =XLOOKUP(G3#+0.583333333333333,Table1[Date Time],Table1[Confirmation Time],"On Time",...

"I understand it is not the easiest, but I reckon it's possible. Or to put it in another way, the task I've been asked to complete seems really compli...

Hi Maarten, You CAN have a PivotTable that shows the capacity and hours by week and person using data from multiple tables. However, you CAN'T have...

Hi Pablo, I think the days of printing are mostly over. I survey my users to see what the smallest screen size is and work to that. Hope that h...

Hi Vicky, You'd need to group the data first, similar to this technique. If you get stuck, please come back with a sample Excel file. Mynda

Hi Kaspars, Thanks for clarifying. Please see file attached which uses the new dynamic array functions: XLOOKUP Function FILTER Function ...

Hi Dave, Your second option is correct; Close & Load to > PivotTable report. Build your PivotTable. Then copy it and paste in a new location...

Hi Stefano, Please see attached - the output of the query is on the Tables sheet in the blue table. If you'd like to learn Power Query, please c...