Last seen: May 12, 2025
Hi Malcolm, Welcome to our forum! It's hard to say the cause, but I'd start by running a repair on Excel/Office. I'm assuming of course that you've...
Not sure, Jim. I'm a bit confused as to what "Section1/" in the error is referring to. I'm wondering if something has a forward slash in a name. If so...
Hi Ayal, You can use the technique in this tutorial: Excel Sorted Dynamic Unique List. Note: you cannot put a formula in the Data Validation dia...
Hi Erik, It's difficult to say without seeing the file and desired output, but you might find some helpful ideas you can use in this Excel Project ...
Yes, you'd have to write a measure that checks if the current date (filtered or row label in the PivotTable) is within the employee's start and termin...
Hi Sarfraz, In that case you can ask Power Query to match 3 columns. See example attached. Mynda
Hi Sarfraz, All example dashboards (other than those in my Excel Dashboard course) that I have built are already available to download for free fro...
Good luck, Sally!
Hi Shawn, Are you able to merge the two reports into one table? Presumably there is a 'terminated date' column and any active employees will have a...
Hi Dieneba, There's no operations in the Middle East, so when you filter for that department, no results are returned. If you change the Department...
Hi Sally, I'm assuming that your Project data is online since you're looking for a URL. If so, at this link under point number 4. Determine your Pr...
Sounds like you need to Pivot the data. Select the Heading column > Transform tab > Pivot Column. Select the Values column from the drop down an...
Hi Jennifer, The Pay Period slicer will only grey out if the Fiscal Year Slicer is also connected to both PivotTables or, the Pay Period slicer is ...
Hi Alison, I've moved this topic to the Power Pivot forum. It's impossible to troubleshoot without seeing your file, or at least a desensitised...
Hi Allison, The CUBE functions are unlikely to be the cause. It's more likely that you have a PivotTable that's in the same column as your up/down ...