Forum

Yes, please send it to website at MyOnlineTrainingHub.com

Hi Lea, Excel.CurrentWorkbook requires the data to either be in a Table or named range. It cannot see unnamed data. If you don't want to name the d...

Hi Andy, Probably. Post your question and VBA code and file in our VBA forum where someone can help you. Please also advise them that you have cros...

Dynamic Array functions do not work inside Tables. Remove the Table formatting and use regular cells when working with dynamic arrays. You can use ...

Hi John, Try this: in the Power BI service click on the cog icon in the top right > Admin Portal > Tenant settings > scroll down to 'Integ...

Hi Philippe, In the top left of the Error Checking dialog box it tells you the cell with the problem. You can also click on Edit in Formula Bar and...

Hi Andy, This is a common problem with Pivot Charts. You would need to set the items in the Slicers to 'show items with no values' so they are alwa...

Hi Stephanie, Please see this tutorial on the different ways you can locate and view your content. You may also find Apps and the datasets hub usef...

Hi John, I'm not sure what the cause of this is. I can still see the filled map visual however, I had another student report the same thing last we...

Thanks, Robert! And you to 🙂

Glad you got the PivotTable doing what you want....and managed to share the file 🙂

Hi Robert, I would put all 29 million rows in a single CSV file. Use Power Query to get the CSV file and do the lookup in Power Query using Merge T...

Hi Garth, HNY to you too! The file hasn't uploaded. Maybe it's too big for the forum limit? When it uploads correctly you will see it attached i...

Hi Garth, Welcome to our forum! Please try uploading your file again. You need to click the 'Start Upload' button after selecting your file, then w...

Hi Maria, For your desired result you'd need to perform a COUNTIFS for the count of delay and only return the name using FILTER. Alternatively, you...