Forum

Hi Peg, Welcome to our forum! It sounds like you're using all the relevant tools for protecting your data integrity. Obviously, you can't preven...

Hi Lenka, Welcome to our forum! Correct, the data split over multiple sheets means you cannot connect a single slicer to each PivotTable. Instea...

Hi Doug, You can use INDEX & MATCH with COUNTIF for this. See file attached. Mynda

Hi Cynthia, Thanks for sharing your file. The problem is the dates in column A of the Data Table are text and Excel can't read them as dates. They ...

Hi Doug, Please upload a sample Excel file. Be sure to include a few students' data so we can see the layout of the table. I think you can use a fo...

Hi Kelli, Welcome to our forum! That's odd. Are you logged in? Mynda

Hi Anita, I think Jessica is picturing the data in PQ is in separate columns as it appears in your screenshot, but presumably you have one column c...

Hi Michele, If you look at my Project Management dashboard you can modify it so that the Project name appears in the highlighted cells instead of j...

Hi Anita, What you want to do is group AV together and PV together and then take one group from the other, but when you group items in regular Pivo...

Hi Raymond, Great to see you're making use of the new dynamic array functions. You should be referencing the spilled results of dynamic array formu...

Hi Pieter, You need to perform a logical test to check if the rows in the UpdateColours table = the 'Old' value in the TextSubs query. If TRUE, the...

Hi Mike, Welcome to our forum! Glad you enjoy my videos There's no built-in way to automatically move the PivotTables closer together as rows b...

Thanks for clarifying. Power Query it is then. 1. Format the data on each sheet in an Excel table (CTRL+T). The tables will be named Table1, Table2...

Thanks for the file. What version of Excel do you have? If you have Microsoft 365 or Office 2021 then you have the new dynamic array functions, which ...

Thanks for the screenshots. The data types for those columns are not set in Power Query. Both are type 'Any'. If you set the data types, do they then ...