Join 3,557 readers in helping fund MetaFilter (Hide)

10 posts tagged with spreadsheets and resolved. (View popular tags)
Displaying 1 through 10 of 10. Subscribe:

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