Forum

Hi Julian, If you have Microsoft 365 you can use the new dynamic array formulas. e.g. where your sum is in cell A2 you can use this formula: =-S...

Hi Fahruk, Welcome to our forum! Thanks for sharing your file and example of the problem. Unfortunately, Excel wasn't designed to work with multipl...

So pleased it was helpful, Ricardo!

Hi Julien, As mentioned in my email reply to you, please upload a sample Excel file containing your data so we don't have to do the work for you. I...

Hi Floyd, Welcome to our forum! Can you please upload a sample Excel file that shows the desired result for the examples above. I'm not sure I shou...

Hi Ronald, Glad it's working now. When you change a date using Locale you don't need to change it a second time. It should already be in your lo...

Hi Ronald, The Region and Departments in the Parameter table are looking for data validation lists that aren't there. My bad, I didn't clear them o...

Hi Ricardo, It's inefficient to nest XLOOKUP like this: =XLOOKUP(C11,'Ambient 1'!$E$3:$E$10,'Ambient 1'!$F$3:$F$10,XLOOKUP(C11,'Ambient 2'!$E$3:...

Hi Alex, You can't conditionally format the Sparkline line. The best you could do is colour the cell fill for that Sparkline using conditional form...

Hi Robb, Have you tried right-clicking one of the value fields in the PivotTable > Show Values As > % of Parent Row Total? Mynda

No, Power Query cannot refresh password protected files.

Hi Ron, The message screenshot didn't upload. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside...

Hi Ronald, The new/updated version of the Power Query course doesn't include a Notepad++ file in the practice materials. That's only available in t...

Hi Dario, Great to see you're practicing. There is an alternate file under the video for that lesson that you can use. Be sure to check for notes u...

Hi Kauser, Welcome to our forum! Thanks for sharing your file. The structure of the data is not suitable for PivotTables. It should be in a tabular...