Forum

Hi Adam, I can't reproduce the issue. When you have confidential data you can create another file with dummy data or remove/replace the confidentia...

Hi Melanie, Welcome to our forum! In future, please start a new topic for a new question. You can calculate the duration by adding completed day...

Hi Akansh, You can't do this with a pie chart. If you have Excel 2016 or later you can use a Sunburst chart. Your data needs unpivoting though. See...

Hi Stephen, Some questions to clarify: 1. What version of Excel are you using? If you have Office 365/Microsoft 365 then you can use dynamic arr...

Hi Asad, The complete formula is in the video description immediately below where you found the link to download the Excel file 🙂 Here it is agai...

Hi Adam, It should simply return a group with zero total. Do the zeros show as errors before you applied the grouping? I'd try replacing zeros with...

Hi Dianne, This is an 'average of averages' problem. The grand total average figure is not the average of the regional averages shown in rows 12:23...

Hi Ben, This will be caused by the data model relationships not being set up to support the chart you want to display. I suggest you watch session ...

This was covered in a video tutorial just last week: select multiple items from a drop down list.

Glad I could help. The better way to resolve the date issue is to use Change type > Using Locale... as you had already done for the other date fiel...

Hi Fred, Thanks for your file. I think it's best if you use this technique to get files from a folder. This will allow you to filter out the sheets...

Hi Laurel, Welcome to our forum! Thanks for sharing your file. You need to do two things: 1. the values in the green series in column D must ...

The errors you're getting in Power Query are because the source files are formatted d/m/y and your regional settings are m/d/y. Power Query tries to i...

Hi Haritha, You can't sum the 'BadHires' field like that because you'll be double counting some Employee ID's. e.g. EmpID 55512 has a total of 2 fo...

Hi Faryal, I think I finally understand! You want a dependent data validation list as described here. It was confusing because you have the 'depen...