Forum

Hi Mohammed, What issue is that exactly? Did you get an error message? Mynda

Hi Carolyn, When you look at the Queries pane in Excel do you see any queries with errors under the query name? Mynda

Hi Ed, Congratulations on completing the course and all your hard work! You can email the homework to [email protected] I'm lookin...

Hi Karen, It's not clear if you have a new workbook each day. If so, you can copy the query out of the advanced editor and paste it into a blank qu...

Hi Karen, You can just filter out the header rows by deselecting them in the filter drop down. Mynda

Hi Mitul, Your data structure is all wrong for copying a formula down a column. I recommend you read this tutorial on how to write formulas efficie...

Remove the totals, that makes it consistent. Then you can just modify the first formula for the whole column: =GETPIVOTDATA("Sales",$J$15,"Region","No...

Hi, The PivotTable technique Catalin describes is explained in this tutorial: Mynda

Hi Shannon, In lesson 7.05 I tell you how to handle Formula Firewall issues. Mynda

Hi Rod, I'm confused by this sentence: "I can print out a list but I then have to select the patients by their identifiers in their column manually...

Hi Mitul, There's no easy way to write one formula you can copy down column K in the 'Data for 2015..' tab because the layout is not consistent i.e...

Hi Rod, Power Query only loads a preview of your data in the Query Editor. This helps it remain responsive while you're editing and transforming th...

Hi Teddy, I couldn't reproduce that issue. I added more dates and more legend items to my column Pivot chart and the formatting remained. I'm using...

Hi Griff, I don't know anyone in Perth, but I'll email you with the contact details for someone who may be interested in traveling. Mynda

Hi Rebwar, Sorry, I don't understand your question. Please upload a sample Excel file and include the desired outcome for your examples so we can u...