• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula required to update the result


New Member
Dear Experts
I need an excel formulas to update the excel sheet attached with the requirements needed.

Objective is to collect data for project management, there will be an excel sheet for each Project which includes action open date, closed date, action owner, due date, overdue date etc.... I need the sheet called "Department Actions by Month" to collect all the data I need from Project Sheets.

For example, How many actions are open for the month of January for the department of supply chain, how many actions are open which passed their due for the month of January for the department of supply chain etc...



New Member


Well-Known Member
I can get you part of the way there using Power Query and parameters for the Department and Month. Here is the file. With your current set up, I have not been able to parametize the type of Action. This may be something you wish to do after isolating the month and department within PQ