Forum

Whether you make the changes in the sample or the final query won't make any performance differences. If you're able to make the changes you need in t...

Looks like a rendering issue. Have you tried viewing the workbook on a different PC?

Hi Rod, It's ok to make transformations in the combined query, except where those transformations must be done before combining the files. e.g. unp...

Hi Jignesh, Welcome to our forum! If I understand correctly, you want the data split into separate sheets based on the SheetName field. In which...

Hi David, If your ledger columns are the same as mine with the exception of your new column for the group, then the first column in the Ledger tabl...

Yes, you can factor it into the formula, but first you must add the column and split the units as I explained above. Then you can use SUMIFS to only i...

The SharePoint connectors are only available with a Microsoft 365 Apps for Enterprise license. Please check the File tab under Account in Excel to see...

Hi Kiran, Welcome to our forum! What I recommend you do in the situation where you only sell part of your portfolio is to split the original pur...

Hi Stephen, I think what you want is the wrong approach. The current layout of your data is correct. i.e. it's in a tabular format. Your goal of "H...

Please share a link to it on DropBox or OneDrive or similar online file storage facility. Or even better, just create a small sample file that illustr...

Hi John, I've not personally experienced this. I recommend you follow a process of trial and error, deleting the formulas that get deleted automati...

Hi Shyna, I think you misunderstand the requirement. They're not looking to see if Excel has the same/similar functionality as Power BI Desktop, t...

Hi Charles, You didn't upload your file. After selecting the file, click the 'start upload' button and wait for the grey tick beside the file size ...

Hi Keith, I'm not aware of any way to create an input mask, sorry. You can't create a lookup table as such in the form, but you can use Power Qu...

Hi Cedric, Check out Catalin's workbook as it allows you to choose both the part number and month. Mynda