Last seen: Jun 30, 2026
Hi Karin, Do you want 1,2,3,4,5,6,7 in one cell, or split over 7 columns? Also, how would you handle 1-13? Please upload a sample Excel file wit...
Hi Guilherme, The workbooks are available for download in a zip file from the very first lesson: 1.01. Please let me know if you have trouble fi...
Hi Susan, You need to wrap your date in the TEXT Function. e.g. ="Age Profile of Current Clients as at "&TEXT($B$1,"dd/mm/yyyy") Mynda
Hi Ehans, Sorry, I misunderstood your question. I thought you didn't want to use the automatic groupings available in Excel 2016. Yes, they are muc...
You're welcome, Patrick 🙂 This post may help you grasp dynamic named ranges. Mynda
I should have also commended you on your clear and concise explanation included in the Excel file. Simply perfect. Thank you for making it easy to und...
Hi Patrick, I'm pleased to see you found the Slicer filter technique useful. I think your use of INDIRECT in your dynamic formula is causing the...
Glad you figured it out, Jim. Microsoft really should remove the merge cells feature and replace it with 'Center Across Selection', as this is far ...
Not sure you can buy Excel 2010 standalone anymore. If your company has a licence agreement then you should be able to install it from a master copy. ...
Hi Pam, I know it's very confusing and frustrating. Here are your options: Excel 2013: Office Professional Plus or the Standalone version of E...
Hi Ehans, If you open my original file again and look at the Data table in Power Pivot you'll see I had added some calculated columns for the Month...
Hi Ric, A line chart will only skip empty cells that are actually empty. A cell containing a formula will never be interpreted as empty by a line c...
Hi Joe, When getting data from the web you are limited to websites that structure their data in a HTML Table. If they use JavaScript to build the t...
Hi Marianne, Just to be clear, Catalin is referring to the Text.Contains function in Power Query, not Power Pivot. Mynda
Hi Marianne, The SWITCH function is not case sensitive but it does require an exact match and you can't use wildcards. So, you have to account for ...