Forum

Hi David, The only way to remove blanks from Slicers is to ensure they don't show up in the PivotTable, and you can do this by filtering them out. ...

Cheers, Todd. I think this is probably a candidate for a recursive lambda function, but I didn't have the headspace to write it last night!

Hi Todd, Thanks for clarifying. I simplified it from this: =IFERROR(VSTACK(FILTER(FILTER(DROP(SORT(UNIQUE(TOCOL(D60+DROP(REDUCE(0,E60-D60,Custom...

Hi Lori, Welcome to our forum! Please upload an Excel file with some dummy data, the PivotTables and a mock-up of what you'd like to see so we c...

Thanks for clarifying, Todd. That sure is a doozy! I couldn't follow how you're supposed to fill out the flexible working table to trigger the formula...

Hi Rose, The issue is that you haven't changed the date data type using 'change type using locale'. Please read the file called 'Read me first' t...

Very nice, Todd. I'm not sure where the 9 day fortnight column is that you're referring to. Here's a tip for conditional formatting: This formul...

The dynamic named ranges refer to the CUBE formula table, not the source data. You then use those names in your chart, as explained in the tutorial ca...

The dynamic named ranges are for the data that feeds the chart so that as you add more months to your source data, those should feed thorugh to the CU...

Hi Rik, Welcome to our forum! Please try uploading again. Be sure to click the 'start upload' button and wait for the grey check mark beside the fi...

Hi Bax, There's no native way to connect. You can either write your own FTP scripts to download the files from the FTP server to a local folder, or...

Hi Ashley, The SharePoint connector is only available in Excel 2019 or 2021 Professional Plus or with a Microsoft 365 Apps for Enterprise license. ...

In that case I would rearrange the data so that it is already stacked vertically because there is no easy way to stack it in a formula in earlier vers...

Hi Dario, Remember, Power Query is case sensitive. You have named the step 'path' lower case and you're referencing it with 'Path' upper case. M...

Hi Michalis, Use this formula in cell O6 instead: =UNIQUE(VSTACK(A6:A20,C6:C20,E6:E20,G6:G20,I6:I20,M6:M63),,TRUE) Mynda