Last seen: Jun 7, 2025
I didn't notice your post number 6 until now. Sorry for being ignorant, but I don't know what you mean. what would you want to extract and how shou...
I didn't notice your post until today. Looked at your file but have difficulties understanding what you exactly want. You have successfully applied co...
Thanks for the file. But now please explain what you want to do with it/them. Say, you have 10 of these sheets what data would have to be extracted...
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...