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 on Jul 2, 2008 - 6 answers

Why are sine waves considered "pure" tones? Why do we consider sinusoids the building blocks of periodic functions? [more inside]
posted on Jun 28, 2008 - 35 answers

Why do mathematicians (and/or programmers) describe information passed to a function as an 'argument'? [more inside]
posted on Dec 13, 2007 - 14 answers

Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]
posted 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 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 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 on Dec 27, 2006 - 4 answers

Help! Stumped by an SQL problem. [more inside]
posted on Oct 21, 2006 - 21 answers

I'm looking for examples that turn the aphorism "form follows function" on its head. The idea that functions can be inspired by new forms. [more inside]
posted on Oct 19, 2006 - 24 answers

Programming/geometry: in a Flash program (you don't need to know Flash to answer this), I'm trying to place rectangular images at random positions on the screen. There are already images on the screen. I need to make sure that the new, randomly-placed images don't obscure the images already there. [more inside]
posted on Sep 29, 2005 - 25 answers

Why does bandwidth cost anything? Short of hosting companies finding a means to make some money, what is the actual cost justification on charging for overages, etc? Is it a racket or does traffic actually put an expense on an ISP forcing them, in turn, to charge customers? Always wondered. Thanks.
posted on Aug 26, 2004 - 8 answers

All of the towels in my house have a stitched patter a couple inches from the vertical end. Anyone have any idea where this came from, or what the function is? [MI]
posted on Feb 16, 2004 - 2 answers