Forum

Hi Cindy, Have you tried splitting the column by delimiter using the - as the delimiter? Then you can 'format' the column with Trim to remove the e...

Oh ok, in that case the stacked column makes sense 🙂

Hi Kobus, Please see the attached file. I've inserted a combo chart with a clustered column for FTC, Rockfill and 44C, with TK001 as the line. I do...

Hi Jynell, The only way to do this is to split the 'main antibiotic' data into separate rows, which you can do with Power Query (see file attached)...

Hi Jim, Are you saving a copy of the file? Are other users opening the file and saving it? If you can figure out the cause and reliably reproduc...

Hi Alison, When you import files from a folder you can modify the 'sample query' and promote the first row as headers. This will then apply that st...

Hi Jim, I'd not heard of this issue before but I managed to find this post suggesting it is a bug with an older version of Power Pivot. You've not ...

Hi Aye, Not that I know of. If you CF'd the total then it'd probably always meet the criteria, which would undermine its usefulness. Mynda

Ingenious, Catalin!

Hi Rita, Usually you'd use dates and time intelligence functions for this, but you don't have a date table, so you can add an index column to the S...

Hi Craig, The free Excel course is designed to get beginners up to basic level, so it's not going to be much help to you. You'd be better off with ...

Hi Christoph, With Power Query you can connect to SAP HANA Databases. Mynda

Hi Tracy, This will be your email system filtering the email. It's either going to a junk folder or it might be caught before even being delivered....

Hi Linda, My suggested formula was just that, a suggestion based on what you already knew, but in hindsight I should have noticed that you were try...

Hi Robert, The file didn't upload. After selecting the file, you need to click the yellow 'start upload' button. Mynda