Last seen: Apr 29, 2025
The file did not come through. Please try again and press 'Start upload' (and wait until it is complete) before submitting your reply.
"Jan" can be any date from January 1 through January 31. Add 90 days and you end up at March 31 (Mar) and April 30 (Apr). With 45 days this would be F...
With all due respect, I mentioned I wouldn't be able to answer immediately. So please do not be impatient. My involvement here is voluntary and only w...
The system isn't working with me today and I obviously wanted to write in post# 6: "A regular pivot table can not handle ..." I'll get back to y...
A regular pivot table can handle such Current YTD totals. You'll need to write a DAX measure in Power Pivot for that. I'm on Mac right now and not clo...
OK, looked at the file. But I do not see a Running Total anywhere, so I don't understand the question.
I noticed three same files in the attachments and tried to remove two before answering. All three are gone now. Can you please upload one again. Sorry...
Perhaps like in the attached file, wit the help of Power Query as suggested by Anders.
Could you upload a PDF and the Excel file that connects to it? Difficult to analyse the issue, otherwise.
On the first point, I'm pretty sure that the dashboard in the video contains a formula that comes even close to the 8K character limit for formulas. S...
Without seeing the data and the desired output it's difficult to comment on alternative solutions. Though it indeed makes sense to have one entry for ...
Glad we worked that out!
Yes, let's forget about VBA for now. I believe the attached (very crude) PQ solution does what you have in mind.
You can transform the list of texts to a list of numbers by wrapping the Text.Split in a List.Transform function. Table.AddColumn(Source, "Select...