Search:

Type: Posts; User: Puck101; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    440

    Re: Updating an existing PowerQuery formula?

    Hi theBardd, thanks for replying and your offer of help but I've appeared to crack it via trial and error. I found a connection table in Manage data which I needed to extend the date range, once...
  2. Replies
    3
    Views
    440

    Re: Updating an existing PowerQuery formula?

    I don't know if this helps anyone provide any advice but I've noticed in the pivot table that the year is listed but for 2019 it is blank? Could this be the issue? When I look at the data source it...
  3. Replies
    3
    Views
    440

    Updating an existing PowerQuery formula?

    Hi, is it possible to simply update an existing power query with no knowledge of how they work?

    I have a calculation file which I inherited and want to update it to account for the current year...
  4. Help from a Graph Expert, please - Comine stacked graph with secondary axis

    Hi all,

    Firstly, I'll start by saying i'm a complete graph novice so this might be really simple but I've tried reading through loads of posts and just cant seem to find the answer.

    I'd like to...
  5. Re: Returning only unique numbers using COUNTIFS, can it be done?

    Thank you
  6. Re: Returning only unique numbers using COUNTIFS, can it be done?

    Sorry yeah I mis-understood the question, I want it on unique account numbers and months (and sales person and value). When I read your question I read the dates 1st Jan and 2nd Jan in this case I'd...
  7. Re: Returning only unique numbers using COUNTIFS, can it be done?

    I don't think so unless I'm mis-understanding as that doesn't work with the other elements/criteria of the COUNTIFS. For example, there may be an account that appears multiple times so doesnt have a...
  8. Re: Returning only unique numbers using COUNTIFS, can it be done?

    Hi, Just unique accounts. All the other criteria is just basically filtering the data for a summary so I can report on each sales person, for each month and where the sales are greater than 299, but...
  9. Returning only unique numbers using COUNTIFS, can it be done?

    Hi

    I have a table of data that I am using countifs to return the number of accounts that meet my criteria, the problem I have is within the data I have multiple rows of the same account so they...
Results 1 to 9 of 9