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]
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]
I need help taming a very long list of numbers into useful tabulated data, in Excel. [more inside]
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]
Probably a simple Excel copy/paste issue... [more inside]
ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
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]
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]
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]
My Google spreadsheet collapsed itself in the middle somehow. How do I get it back? [more inside]
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]
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]