Last seen: Aug 21, 2025
Please upload a file (or files) that demonstrate the actual structure (or lack thereof) of the data. Without that, it's difficult to help.
I'm really sorry but don't understand what I'm looking at nor what you need. It's difficult based on a picture alone.
In PQ you can navigate to the Folder containing your files. Press 'transform' and filter for the file extension you want to connect to. In your case "...
As I understand, you renamed column headers in a table that sources a pivot table. Correct? Let's say one pivot table (pt) uses the Manager column ...
From what I understand, you need to un-share the Pivot Cache for both pivot tables. It is explained in this blog post by Mynda: Excel Pivot Cache •...
@Hans To avoid OFFSET, in modern Excel you use the # sign to refer to an entire spilled array. So, in your example you can refer the named range It...
Consider it closed, but you should have informed us about cross-posting in your first post.
Difficult to visualize what you are trying to achieve. Can you upload a file (remove any confidential information) that demonstrates your situation. A...
There's nothing wrong with the dates in column L (neither with the ones in F:H). It's the ones in columns M:X. These are the ones where I replaced - w...
Regarding 1, your local system settings dictate how dates are recognized. So, your Windows environment is set a format yyyy/mm/dd. If you now enter or...
OK, My bad! I didn't read the 'upto' in your initial question. See attached. And just understand, this work for upto the limit in the KM column. No...
I misunderstood and though the allowance would be per KM. If that's not the case, just remove the multiplication bit of the formula. That would then b...
OK. See attached. I included your form in the file I sent earlier. See if you can get it to work.
A screenshot isn't really helpful. Especially as it doesn't include the column and row headers. Better to upload your file. When you do that, please ...
Best to create a small lookup table with the rates and 'from KM' limits. You can then use the LOOKUP function to retrieve the correct rate/allowance p...