Last seen: Aug 28, 2025
Can't see what's in the 1st screenshot but the 2nd one still shows the columns of a data type "Any" (i.e. ABC123). Set the data type to 'Date'. If nee...
Please have a look at the attached file and see if it does what you need.
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...