Forum

Hi Yuan, Just change the data type to Date. It will remove the time component. Mynda

Glad I could help Graham! It's wonderful to hear you found my videos helpful too

Ah, ok. In that case Teams has no bearing on the file's functionality since you're using it in Excel Desktop. Please see this tutorial on workbook pro...

Hi Anton, Welcome to our forum! Can you please upload your Excel file so we can see how your workbook is structured and identify where things ha...

Hi Howard, With complex conditions like this it's easier to add some helper columns when working it out. In the attached file I've added some table...

Hi Heather, Welcome to our forum! If you're using Excel embedded in Teams then you're effectively using Excel Online and you cannot execute macr...

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...