In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

Trying to get some modified AVERAGE results in Excel. [more inside]
posted by FatherDagon on Aug 5, 2009 - 5 answers

I am trying to partially automate a tedious list comparison procedure, I think I should be able to do it through excel without any coding (which I don't know how to do) [more inside]
posted by dripped on Mar 19, 2009 - 3 answers

Within cell C2, If the content of a cell in $A$10:$A$900 is the same as the content in A2, I would like Excel to Average the contents of column H in the rows that match A2...does that even make sense? [more inside]
posted by InfinateJane on Jul 2, 2008 - 6 answers

Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]
posted by chuckdarwin on Jul 4, 2007 - 6 answers

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

Excel question: How to define a range so that it always adds up to a constant value. [more inside]
posted by corpse on Jan 16, 2007 - 20 answers

Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year) [more inside]
posted by brent on Dec 27, 2006 - 4 answers