Forum

Hi Graham, Welcome to our forum! You can use the following formula to convert the date serial numbers to text and then back to a number: =VALUE(...

Hi Cam, A PivotTable would give you a layout like this: Project 2022 2023 Katroc Jan 13, 2022 Sevron March 12, 2022 ...

Hi Howard, Thanks for clarifying. Another question: The closing balance doesn't look right to me because it doesn't reconcile to any of the numb...

Hi Michael, You definitely can't do this with a regular PivotTable. In the file attached I've inserted a measure in a Power Pivot PivotTable. My...

Hi Howard, Your question isn't clear to me, sorry. You mention a buffer in cell E1, but then refer to F1, which is an empty cell. Is this a mistake...

Hi Pooyeh, Great to hear you've found my videos helpful. I don't have anything on timelines and milestones specifically, sorry. However, you might ...

Sorry, I should have set the summarise setting to Average in the PivotTable, however, that still won't give you the calculation you want because it's ...

Hi Cathy, Welcome to our forum! Yes, you can use Power Query to get sheets from multiple files in a folder. Mynda

Hi Justin, 1. Yes, however I'm not sure what you're expecting to do with the max limits you mention. 2. If your data is split over multiple shee...

Hi Bruno, Seeing that your receipt table contains a distinct list of TransactIDs, you can use this as your lookup table. You can then create a Pivo...

Hi Benoit, Are you able to share your file? I can enter the formula in English and then when you re-open the file it will translate it to French fo...

Hi Michael, In the attached file I've created a regular PivotTable with the year on year % change, but you'll see in the Slicer that you need to se...

Hi Lea, See file attached. Note: if you add fields to the rows area in the PivotTable with the calculated field you will get the 17% applied to eve...

Hi Jessica, How about if you added a conditional column that checked if the Event column contained Pay Day AND the length of the text in Event was ...

Hi Steve, Welcome to our forum! I can't see which data validation list you're referring to. The one in column D is showing a #REF! error and the...