Forum

Hi Louise, Welcome to our forum. Is the order of the Ps and Qs important, or just the number of them? Mynda

You can use Power Query to map dates to a 4-5-4 calendar or formulas to convert dates to 4-5-4 calendars. Either way, you need another table that cont...

Hi Keivan, File isn't attached. Please be sure to click the 'Start Upload' button after selecting your file. Mynda

Hi Keivan, Please upload a sample Excel file. Mynda

Hi Therese, Welcome to our forum! You need to create another table that has the number you want distributed and it's corresponding date. You can...

Hi Ben, I would recommend Power Pivot DAX measures for this as your table solution with formulas won't automatically grow with new data. In the att...

Hi Subash, FIFO calculations are not straight forward, but this post explains how to create them. Mynda

It sounds like the axis isn't referencing the axis vales correctly as I can't replicate this issue. Are you able to share your file so we can check?

Hi Peter, I'm not aware of any way to alter users to perform an action, only alerts to let them know they've been given permission to view a new re...

Hi Jacek, If it's 50 separate queries you want outputted, then you need 50 separate queries that you create one by one (after all, they all have di...

Hi Nelson, You can learn about Tables and their structured references here. If you'd like to get up to speed with formulas like this, please consid...

Hi Shannon, In the attached file on the Pivot sheet you'll see I've used a PivotTable to summarise the data, then added conditional formatting for ...

Hi Andrew, In the attached file I used Power Query to unpivot and clean the data. Then I inserted a PivotTable with Slicersto generate the report. ...

Hi Martin, Welcome to our forum! I'm not sure what you mean by 'I've got a number of SQL queries...', where are these queries? My reply below as...

Hi Shannon, Welcome to our forum! The first rule of conditional formatting is that you can't layer them. i.e. only one conditional format will ...