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

    Retrieving Values based on dates

    Andrew Nicholls

      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.

       

      Thanks

      Andrew