12 posts tagged with spreadsheets and resolved.
Displaying 1 through 12 of 12. Subscribe:

Android Widget that displays Google Spreadsheet data?

Is there an Android Widget that will allow me to display a subset of data from Google Spreadsheets? I keep track of my budget in a spreadsheet, and I would like to display the balances in a quick way on my phone without actually having to open the Google Sheets application. [more inside]
posted by SpacemanStix on Sep 20, 2014 - 3 answers

Publish many Google Spreadsheets at once?

Is there a way to tell Google Drive to use the "publish to the web" option--but not for a single spreadsheet, but rather for an entire folder full of 450 spreadsheets? [more inside]
posted by johngoren on Sep 8, 2014 - 1 answer

No, this isn't about EVE Online.

I need help taming a very long list of numbers into useful tabulated data, in Excel. [more inside]
posted by 256 on Feb 28, 2013 - 10 answers

Correlating names between two spreadsheets

I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names. [more inside]
posted by mammary16 on Jan 18, 2013 - 8 answers

Excel copy/paste question

Probably a simple Excel copy/paste issue... [more inside]
posted by xedrik on Jun 8, 2012 - 5 answers

Why don't they teach us how to prep the numbers as well as how to crunch them?

ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
posted by smirkette on Mar 26, 2012 - 10 answers

Have paragraphs. Want just the hyperlinks. In Excel.

Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
posted by randomname25 on May 19, 2010 - 10 answers

Excel Filter: Search the contents of one cell for the contents of another cell, then replace with the contents of yet another cell? Is it possible?

I need to search the text in column A for the text in column B, replace it with the text in column C, and return the new complete string to column D. I've Googled. I've read. I've cried. Can you please help me? [more inside]
posted by Salient on Feb 24, 2010 - 5 answers

Getting Google Spreadsheets to interpret string as formula

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

How do I unsquish my Google Docs spreadsheet?

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

Compare and output greater value.

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

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?

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

Page: 1