Forum

Hi Dieneba, I suspect you missed the step where you replace minus ( - ) signs with blanks before changing the data type to decimal. BTW, I've mo...

Hi and welcome to our forum! It's great to hear you found my videos helpful The built in STOCKHISTORY and stock data types tools can't get your da...

Hi Kenneth, You can use Power Query to unpivot the first table, and then use PivotTables and Slicers to summarise and filter the data according the...

Hi Tim, If the file is not already saved on OneDrive or SharePoint then you can't use a URL to download it via Power Query. You'd have to use Power...

Hi Stephanie, It's great to see you're trying different things. When you make attempts and get stuck, it's best if you can share your file with you...

Hi Sebhattin, Using the example in your file, if you wanted the time bars for Angelini Drehbank coloured purple, you'd use this formula in your con...

Hi Stephanie, The UNIQUE function (to generate the distinct list of objects) is covered in lesson 3.62 and dynamic named ranges are covered in 3.75...

Hi Stephanie, You have to create a summary of the data in a separate table (i.e. where the object number is not repeated), which is another reason ...

Hi Stephanie, That's for sharing the second file. That's the one that would have been helpful from the outset. Sorry, I thought you were havin...

Hi Stephanie, You said my formula wasn't working (which happens to be the same formula Riny suggested). I wanted you to show me your file where you...

Hi Vijay, I agree with Jessica, the question is not clear because you didn't provide an example in the file that shows the desired result as reques...

Hi, You can use Power Query to compare two tables and return matching results as explained here: Easily compare multiple tables in Power Query ...

Hi Stephanie, I don't see where you've inserted it in the file you attached. Note: if you don't have Excel 2021 or Microsoft 365, then the formula ...

Hi Sarfraz, Please see this tutorial on converting numbers to words with VBA in Excel: Note: this is outside the scope of the Excel Expert course...

Hi Mat, I wasn't able to replicate this issue testing with Power Query getting data from inside the workbook and loading it to the data model. i.e....