• 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

    Hui...

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

Search results

  1. C

    Power query changes last years dates to current year

    Hi, I have a power query that gets data from a folder with a number of excel workbooks. It worked well last year but when I refreshed it today all the 2018 dates changed to 2019 in the power query. The dates in the excel work books are in custom format eg 12/01/2018 and one of the power query...
  2. C

    summing multiple ranges when more than one cell meets the criteria

    Hi, I am trying to sum the number of hours each staff member does each month by funder code where the date and funder code needs to be checked first. The timesheets are fortnightly so their periods (as in the attached example) may contain data from either the previous month or the following...
  3. C

    Selecting and moving merged cells content into one cell in correct row

    Hi, I would appreciate any help with the following please. We download a spreadsheet from our intranet in the format shown in the attachment. The problem is column M "outcomes" because there can be more than one outcome per ID in column A. This leads to that ID entry having merged cells across...
  4. C

    Large number of data series all need range changed each week?

    Hi, I have a graph that has 189 series of data. I have a mechanism for selecting which ones to display (use of checkboxes not a pivot table) so that they are not all visible at the same time! However each week I need to add another set of values for each series. Is there an easy way of doing this?
Back
Top