2 Replies Latest reply on Feb 11, 2016 2:07 PM by Jason Cooke

    Collate data above a certain number from several worksheets

    Jason Cooke

      Hi there,

       

      I have seven worksheets (representing days of week) displaying the number of days worked on each worksheet in a month.

      On a different worksheet I am trying to show the culmination of all people from all days where the number is greater or equal to 3.

       

      Basically what I was trying to do was to identify any patterns where people work a particular day/s consistently.

       

      Thanks in advance for your help.

       

      Regards