Excel filter extra row RRS feed

  • Question

  • I have a dataset which my users would like summarize in a number of different ways dependent on the filters they setup, however the SUBTOTAL formula seems to be showing an extra non-filtered record at the bottom of the dataset that should have gone away during the filtering process.  I found a very kludge work around but I would like to find a proper solution.

    We want to see Min, Max, Median, Sum, etc. dynamically change as the user changes their filter data.  I found the following link which gave me a good lead Exclude Hidden Rows from Totals but the SUBTOTAL seems to funk up Excel.  The last row of the table is not properly hidden by the filter and screw up the stats.

    Thank you,


    Wednesday, August 22, 2012 1:15 AM


All replies