summary statistics

  1. T

    Calculate and Report Median on Multiple Files

    I have over 200 excel files that have the same headers but different number of records for each. I need to calculate the median for column F for each file and then report that median (on one file if possible) for each file using the filename of said file. Is this something someone can help with...
  2. J

    Using summary statistics functions in calculated field of pivot tables

    Hi, I currently have a pivot table that returns min(date) and max(date) for each by-group 'Name.' So it looks something like this: Name Min of Date Max of Date John 1/1/2000 9/1/2000 Mary 4/1/1999 3/1/2000 Chris 2/1/2000 6/1/2006 Now I would like to...

Some videos you may like

This Week's Hot Topics