5 Replies Latest reply on Jul 18, 2018 6:25 AM by Patrick Carra

    Calculating the Average by a unique entry in a column

    Patrick Carra

      I would like to calculate the average of the Duration by the number of entries.   Another complication is that I have records that have NULL in Date2 that I need to exclude from the calculation.  I have calculated the Duration using DateDIFF('day', [Date1], [Date2]).  My worksheet is set up like this:


      Vendor     Date1     Date2     Duration


      Any help is greatly appreciated.