Forum

Hi Victor, Great to hear you're enjoying my videos 🙂 The greater than and less than dates are automatically added by Excel when you group a da...

Hi Warren, Welcome to our forum. I haven't experienced this problem before, but a Google search brought up these threads which might point you in t...

Hi Bill, Why don't you use Power Query to do this for you? Presumably the data is in a CSV or Text file in one column. You can use Power Query to g...

Hi Sari, No, sorry, you can't paste into the newly inserted rows because they're inheriting the protection from the row above and columns H & I...

Hi Bruno, You haven't said what the file type the data is in that you're trying to get from Google Drive. That said, have you shared the file on Go...

Hi Mark, Welcome to our forum! The reason you're having trouble is because these analysis type tasks shouldn't be done in Power Query. Power Query ...

Hi Francis, What do you mean 'it changes'? I can't tell what has changed from the images attached and the totals at the top are the same. Mynda

Hi Allison, I was able to reproduce it using Power Query to load the data to Power Pivot. I found if I unchecked the 'Hide all field buttons' optio...

Hi Chris, I don't see a way to do this any easier/with less tables than you're already using other than writing a custom function, but this doesn't...

It is a mistake to use formulas for this. You are playing with fire because the chances of formula errors are high. I recommend using PivotTables as A...

Glad it was helpful, Punith.

Are you sure the .xlsm versions of the .csv files are smaller? Usually it's the other way around i.e. Excel files are bigger than csv files.

Hi Robert, The curly braces indicate that this formula was entered with the key strokes CTRL+SHIFT+ENTER to make it an array formula, as Phil expla...

Hi Erik, No image attached. Be sure to click the 'start upload' button after choosing the image file. Note: I suspect the image won't be enough for...

Hi Em, Looks like this is a limitation caused by the calculated items. I've never noticed it before as I don't tend to use calculated items and fie...