Last seen: Aug 15, 2025
@jjmadness As an alternative, I would personally favour flattening the data with Power Query and then create a summary with a simple Pivot Table wh...
@jjmadness OK, then you need the FILTER function inside the LET. That allows you to 'pick-up' multiple rows. Then TAKE and DROP to narrow down the ...
@norman Well, then you create a pivot table that has all three elements in the row area. Something like this: Added it to your file. Are y...
@norman Any reason why the file is an "xls", rather than "xlsx"? That's an ancient format. I've saved it as an xlsx and used Power Query to flat...
@norman There is no file with your post. Please try again.
@jjmadness Oh yes! Now I see the file above your first post. Didn't notice that. Sorry. Please find a solution in the attached file. It's a bit c...
Best if you can upload a file with an example of your data and the result that is expected. Otherwise look into using the SUMIFS function as that's th...
@chosen67 Your issue has nothing to do with the fragmentation and duplication phenomena described in the video. Change the rule to: =COUNTIFS($C$...
@chosen67 Please try uploading your file again. It didn't come through. Otherwise, save it to OneDrive or similar and share the link that gives ful...
@abdallahh Most likely due to the fact that your dates are in the wrong format. Which locale does your setup expect? dd/mm/yyyy or mm/dd/yyyy I ...
Aha! Then please explain all the logic to be applied. Edit: Perhaps the attached file does what you need.
@lanser Difficult to visualise exactly what you are dealing with, but my gut feeling says that you could unpivot the data first and then use the “At...
@j8150outlook-com Thanks. Would actually like to see the query of the 'invoked function'. Does it include some filtering step that may exclude the l...
@jessica5 Not sure I fully comprehend your logic here, but note that 0.44 equals 44%. You probably want to use 0.0044 (=0.44%) in your format. And I...
@j8150outlook-com Difficult to say without seeing (at least) the query and a screenshot of the folder with the 25 files in it. Make sure that the fi...