Last seen: Jul 7, 2026
The attached file contains the PQ clean-up query and the resulting table loaded to the Query sheet. You'll note that this table has the same dimension...
But why don't you use PQ to do this one-time cleaning for you. It takes about 30 seconds to connect to FX, select all columns and execute the Clean an...
I tried replicating the issue but could not. The attached file contain a workbook with three sheets where I used VSTACK in a 3D reference. does this r...
I noticed that you tried to construct the column headers by transposing and then merging. That could work but involves quite a few steps and I thought...
See if you can follow the steps in the queries that I added to your file. You may want to do some clean-up (removing some characters, setting data typ...
Nice! @Velouria
Try this: =FILTER(FILTER(tblAcct,$H$2=tblAcct[BankName]),X1:X7)
Then I just misunderstood your intentions. Forget my suggested formula change since your own seems to work for you. Going back to your original que...
See if the attached file does what you need. It contains a rather straight-forward query. I haven't put any effort into making it look nice though. ...
The attached file contains a rather clunky (but working) solution I made up myself. It requires a certain amount of M-code manipulation but it's not t...
I assume you refer to the -2% that shows up in C14. Why should that be zero?
The support page for the SUBTOTAL function is clear about that. "If there are other subtotals within ref1, ref2,… (or nested subtotals), these nest...
Make sure you connect to the named cell with PQ. Right-click inside the 'cell' that has thecae for the current month and select 'Drill down'. That wil...
Your file links to a source that we can't access. You can click on the filter button in the column header (similar to Excel) and select only the locat...
The screenshot didn't show. Please try again and press "Start upload" before you submit your reply. Regarding the need to allow users to add comme...