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...
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...
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...
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?