2 Replies Latest reply: Feb 11, 2015 6:34 AM by Andrew Nicholls RSS

    Retrieving Values based on dates

      Hi All,


      I'm encountering an issue where I have an Excel document with multiple users and the times that they've done work for each month. Each user is available for a specific amount during each month and because they enter figures in for each day the values are replicated. Is there a way of finding the distinct values? I tried using =SUM(DISTINCT AvailableHours) which works fine providing each user is available for a different amount of hours. What I need is something that works to bring back each value only once per month.


      If you are unsure what I mean please ask and I will try and elaborate more.