Last seen: May 15, 2025
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....
Oh, by the time we got the question and example clear I'd forgotten you didn't want to use a PivotTable, sorry. You need Microsoft 365 or Excel 202...
Hi Priscilla, The formula you're using the generate the title must be affected by the filter on the State slicer. It's hard to say without seeing a...
Hi Stephanie, Thanks for clarifying. You can use a PivotTable (with data added to the data model) to do this. You need to include the 'Items' field...
Great to hear! The files didn't get attached. After selecting the file you need to press 'Start upload' and then wait for the grey check mark before s...
Hi Valerie, It's very difficult to follow without a sample file. The KPI visuals require a date dimension, so maybe you haven't given it enough inf...
Hi Stepahnie, Thanks for sharing the file. I'm a bit confused as you say you want the value for those with an amount of zero. How would I be calcul...
Hi Sebahattin, Yes, you can add more conditional formats (one for each project) that colours the cells, but if you have a lot of projects, then it'...