I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily? [more inside]
posted by soulbarn on Aug 12, 2009 - 3 answers

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

I need to merge two Excel sheets with some common fields, but the most advanced formula I've ever used is Autosum. [more inside]
posted by thebazilist on Jul 7, 2009 - 9 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

My Google spreadsheet collapsed itself in the middle somehow. How do I get it back? [more inside]
posted by mathowie on Feb 5, 2009 - 5 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 want to be able to filter my data in Google Docs Spreadsheets like the Data > Filter > AutoFilter function in Excel 2003. [more inside]
posted by Jacqueline on Oct 7, 2008 - 1 answer

ExcelFilter: How can I create a spreadsheet that automatically copies a certain type of cell from one column to another? [more inside]
posted by CXImran on Sep 26, 2008 - 7 answers

I am looking for a way to sort embedded Google Spreadsheets. I am not looking for advanced features or interacting with the data, but ONLY client side sorting. [more inside]
posted by joemako on Aug 11, 2008 - 2 answers

Let's say I have a two column chart, with the following values: [more inside]
posted by underdetermined on Apr 29, 2008 - 10 answers

How can a new company track leads submitted via its website through the sales and post-sales process, simply, automatically, and online? [more inside]
posted by prophetsearcher on Jan 30, 2008 - 12 answers

Looking for open source spreadsheet templates I can use commercially (if it comes to that) for recipes, fitness programs and the like. Why? Because my excel skills suck. [more inside]
posted by cameron.case on Dec 18, 2007 - 5 answers

What kind of software can I use to keep track of information on each client and/or project that I'm working on? [more inside]
posted by iguanapolitico on Apr 24, 2007 - 7 answers

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

Well, the people at iRows are shutting down their service at the end of the year and I need to find a way to share my spreadsheets with other people. As usual, there are some problems [more inside]
posted by killa62 on Nov 15, 2006 - 8 answers

What would be a good way to calculate "fuck-you money"? [more inside]
posted by ElfWord on Sep 28, 2006 - 30 answers

What kind of jobs exist for people who think about numbers and money from a consumer perspective, in a weirdly logical and obsessive way? [more inside]
posted by croutonsupafreak on Sep 11, 2006 - 18 answers

I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste? [more inside]
posted by Happydaz on Jul 4, 2005 - 6 answers

ExcelFilter: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast? [=Text(MI)] [more inside]
posted by mwhybark on Sep 29, 2004 - 8 answers

Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.

One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.

The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.

Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto on May 11, 2004 - 1 answer

I've been thinking about plunking down the cash to buy a licensed copy of MS Office (or Office XP, or Office 2003, etc.) for my new laptop. Can anyone tell me why I shouldn't just run Openoffice instead? From what I've read, it appears that I can "save as" most MS formats with it. Any firsthand experience?
posted by trharlan on Feb 23, 2004 - 19 answers

I'm working with an alphabetical list of email addresses in Excel, approx. 8500 addresses long. Is there any quick way to remove duplicates outside of manually scrolling through and deleting them by hand?
posted by rocketman on Jan 7, 2004 - 7 answers