Forum

Hi Marianne, Is the data in your new file in an Excel Table? In step 5 #Filtered Rows you filter out rows that don't contain a Table. If your new d...

I'm with Frans; overwriting shouldn't be a problem. Another options is to just use a filter on the PivotTable to choose the month's data you're int...

Hi Jason, Glad you got it working. In regards to your #VALUE error in cell C9 vs the formula resolving to a single value when it's in cell C1; t...

Sorry, Anne. I was referring to Power Query. Should check my 'powers' before replying. I explain how to use Power Query to compare lists here: ...

I agree with Sunny. Definintely use Excel Tables for your source data. Here is a tutorial on Excel Tables as they have many benefits. Mynda

Hi Martin, Setting a target line in a bar chart is tricky because you can't create a combo bar and line chart. I see that your vertical axis contai...

Hi Jason, You can't enter a dynamic range formula directly into the data validation source field. You must create a dynamic named range and use tha...

Hi Anne, Session 3.04 shows you what the different join types do, but from memory it's Left Anti. Mynda

Hi Kumail, When you join data together you can only join text to text, and the end result will also be text. You have to convert your month numbers...

Great. I'm glad that helped 🙂

Sorry for missing this question. I don't think you can have one formula for all cells in the SIP table because your first FV formula has the type a...

Hi Kumail, In session 7.02 of the Power Query course I show you a technique for that. Please let me know if you get stuck. Mynda

Thanks for sharing, Bax. Power Query doesn't easily reference rows above/below like you can in Excel. It requires custom functions and the like, so...

Also see if you can replicate it on your PC or another PC. If you can't then it's something specific to her PC.

Hi Anne, I've never heard of that before. Are these cells in an Excel Table or just regular cells? Do other people have access to this workbook? Do...