Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]
posted by itsonreserve on Dec 23, 2009 - 7 answers

I want to start using a spreadsheet to track and reconcile my various accounts. How do I start? [more inside]
posted by reenum on Sep 30, 2009 - 9 answers

How do I select the last number in a column in Open Office Calc? [more inside]
posted by tomble on Jul 9, 2009 - 3 answers

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn on Feb 5, 2009 - 6 answers

I need to transform a big HTML table into something easier to update and maintain. Bonus: I'd like to put it (or its display widget) onto our staff wiki page. [more inside]
posted by lillygog on Nov 12, 2008 - 6 answers

I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind. [more inside]
posted by Jackie_Treehorn on Oct 24, 2008 - 9 answers

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]
posted by niles on Oct 20, 2008 - 7 answers

Using OpenOffice Calc (Spreadsheets) - Is there any way to divide the strings in one column into two by the space in each cell? [more inside]
posted by l33tpolicywonk on May 30, 2008 - 5 answers