Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them?
[more inside]
posted by notcostello
on Jun 29, 2010 -
5 answers
I have an excel 2007 spreadsheet that has 4,000 rows and 6 columns of information. Need help merging some of the rows together.....
[more inside]
posted by bleucube
on Jun 23, 2010 -
10 answers
I have lists, in Excel spreadsheets, that contain perhaps 500 rows of data in three columns: Date, Time and Stock Ticker Symbol. I need a method to correlate those three things with unusual stock activity.
In other words, if column 1 is March 10, 2010, and column 2 is 10 a.m., and column three is INTC, I need to know if something unusual happened - high volume or big price movement - for INTC around 10 a.m. March 10.
Anyone know a program that'll do this?
posted by Flunoid
on Jun 17, 2010 -
11 answers
I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help?
[more inside]
posted by anderjen
on Jun 10, 2010 -
5 answers
Is there a relatively complete movie database in csv or other Excel-friendly formats?
[more inside]
posted by AmitinLA
on May 31, 2010 -
3 answers
Excelfilter: Okay, I'm confident that this can be done in Excel, but I don't know how. Basically, I have a set of samples for which a value (size) was measured at various days. I need some formulas to tell me when the first and last values were measured and what those values were (for each sample).
[more inside]
posted by kisch mokusch
on May 26, 2010 -
9 answers
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 Assist/I don't believe I couldn't figure this one out: I have a table with unique text values. How can I have it act the same way as a pivot table? Sample inside.
[more inside]
posted by yoyoceramic
on May 17, 2010 -
9 answers
How do I obtain a list of all words associated with a list of word roots / stems?
[more inside]
posted by hooves
on May 13, 2010 -
6 answers
Is to possible to map several addresses from an excel spreadsheet on Google earth, Google maps, etc. using a macro?
[more inside]
posted by jefficator
on May 13, 2010 -
4 answers
Can you reccomend me a good Excel 2007 Book?
I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel.
Can anyone reccomend a good book to get that would include information relative to that?
posted by sockpim
on May 5, 2010 -
9 answers
Clipboard and/or Excel question: How can I assign a function key to do a Ctrl+V paste?
[more inside]
posted by crapmatic
on Apr 21, 2010 -
3 answers
MS Excel-filter: I want to be able to search for the second occurrence of a word in column A and then pull the corresponding value from column B. More inside.
[more inside]
posted by prunes
on Apr 16, 2010 -
13 answers
I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out.
[more inside]
posted by digitalprimate
on Apr 13, 2010 -
7 answers
Excel help. In column A I have several thousand numbers. In column B I have several thousand more numbers, some of which are in column A. I would like column C to contain the numbers from column A that are NOT in column B. I would also like column D to contain the numbers from column B that are NOT in column A.
posted by BigVACub
on Apr 8, 2010 -
12 answers
I'm making an archival database (in Excel) with about 10,000 rows and 6-7 columns for each row. I'm doing this so the information will be easy to cross-reference and search. I've never done anything like this before and am looking for books, blogs, etc. for tips, suggestions, and anything that will make my life and this project easier.
posted by melodykramer
on Mar 29, 2010 -
16 answers
I need to organize a spreadsheet of log files into specific columns. The spreadsheet is a converted text column, each log file parses things differently, so column 'a' on one row can be userid, while column 'd' on row is the userid.
I want to organize this spreadsheet, so that column a is userid for all logs. is there a specific excel formula or macro i should use, i was thinking:
if cell contains userid, move to column 'x'. just not sure how to do this.
- Tim
posted by fozzie33
on Mar 29, 2010 -
5 answers
Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.
[more inside]
posted by beammeup4
on Mar 23, 2010 -
7 answers
I have: An excel spreadsheet with a bunch of emails. I need: A self-updating text string that can be copy-pasted into an email TO: Field. I know about C1&","&D1 but is there a way for the list to be automatically updated when I or subtract an email, without specifically having to tell the formula to look in the newly added row?
[more inside]
posted by amethysts
on Mar 23, 2010 -
7 answers
In-over-my-head-Excel-filter: I need to put little braces {like, brackets}around a whole column of values using the concetenate function.. column A has all the values I need braced- but how do I get those same values {braced} in column B?
[more inside]
posted by Philby
on Mar 14, 2010 -
8 answers
What are best enterprise level Web Analytic / Stat programs that work with IIS and Apache sever logs?
[more inside]
posted by wcfields
on Mar 10, 2010 -
1 answer
Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result?
[more inside]
posted by albrecht
on Mar 9, 2010 -
11 answers
ExcelFilter: I need to write something pretty simple in Excel. I have big spreadsheet of data. Some rows are fill-colored, and some columns are fill-colored. I need something that will show me (hopefully in a table or something) the cells that have their entire column colored AND have their entire row colored. Returning the value of the cell would be helpful too. (I have a feeling this is an embarassingly easy question to answer)
posted by demagogue
on Mar 9, 2010 -
5 answers
Mac Excel 2008 Question: how can I change the edit mode when defining named ranges? It's not F2, it's not CTRL-U, so what is it?
[more inside]
posted by fremen
on Mar 8, 2010 -
0 answers
Excel question: I have a list of values, sorted from lowest to highest. I want to rank them. But I have a specific issue with regard to ties, and I'd like to be able to craft an Excel formula which will deal with this automatically, if possible. Full explanation below the fold.
[more inside]
posted by Conrad Cornelius o'Donald o'Dell
on Mar 6, 2010 -
8 answers
In Excel, adding percentages, needing to correct, and having to get back to the original amount. Can I do this?
[more inside]
posted by nevercalm
on Mar 6, 2010 -
5 answers
Excel Checkbox Question. Please help me write a macro that will selectively uncheck certain boxes within a named range. This has driven me crazy all day today.
[more inside]
posted by kev23f
on Mar 4, 2010 -
5 answers
Looking for a utility to take a single original file, and make multiple copies of that file with different file names, pulled from a list.
[more inside]
posted by GJSchaller
on Mar 1, 2010 -
7 answers
Complex Excel question - need to select a range of cells, based on the selection of a separate cell. But wait, it's more complicated than that!
[more inside]
posted by doh ray mii
on Feb 24, 2010 -
1 answer
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
Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily?
[more inside]
posted by Muffy
on Feb 12, 2010 -
8 answers
Is there a way to standardize 'comment' window sizes in Excel?
posted by digiFramph
on Feb 10, 2010 -
10 answers
I have a massive spreadsheet that's simply too difficult to read, because of its size. Is there any way of making a second spreadsheet that is exactly the same as the first, except that the 2nd's cells just show an "x" if there is information in the 1st's cells. i.e., the 2nd spreadsheet would just show whether or not the cells on the 1st spreadsheet have been filled in, but not the actual information itself. If sheet 1 looks like
this, sheet two should look like
this.
[more inside]
posted by omnigut
on Feb 2, 2010 -
15 answers
