Forum

Hi Genevieve, Your data isn't in a suitable format for a PivotTable. You should not have a separate column for each date. You should have one colum...

Hi Richard, Welcome to our forum! Thanks for sharing your files. If your workers make changes to the query output on the 'New Board' sheet, thos...

Hi Doug, You're on the right track wanting to split this data up. As long as each dataset has a common ID you can split this task into separate tab...

Hi Fernanda, You haven't said what version of Excel you have. If you have Microsoft 365 or Office 2021 you can use this technique: And if you ...

Congratulations, Pieter! Great to see your inventiveness with Excel 🙂

Hi Geneviève, The image didn't upload correctly. Please upload a sample Excel file rather than an image. Mynda

Hi Frank, If the data is used in Power Pivot then it should be loaded direct from Power Query to the Data Model/Power Pivot and not loaded to Power...

Hi Lee, Data types are not a formats. Currency is actually the decimal data type with formatting in the Power Query editor to make it look like cur...

Hi Nicholas, Welcome to our forum! Power Query cannot be refreshed online yet, sorry. You have to open the workbook in the desktop app and refresh ...

Hi Frank, We've checked the obvious things so I'm not sure of the cause. I've had this happen from time to time too and I just apply the number for...

Hi Tim, You don't append the sample file queries. You append the final queries for each. The sample file only gets one file, the final query gets d...

Hi Fernanda, If you want the result to be a filtered list then you should use the FILTER function. Mynda

Hi David, Welcome to our forum! No silly questions here 🙂 You can use the COUNTIF function to count how many tasks are completed, which can th...

Hi Cynthia, I don't think IRR is correct to use in this case because there is no 'return' as such. NPV makes more sense. i.e. what's the net presen...

Hi Chris, Are you able to share your file or a sample file that illustrates the issue? It's difficult to troubleshoot without seeing the data. M...