877 posts tagged with excel.
Displaying 351 through 400 of 877. Subscribe:

Word I find software that can get to the root of this problem?

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

Please help me create a mapping macro?

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?

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

Dear Excel 2003, I need my columns back.

A few questions about Excel 2003. [more inside]
posted by Brandon Blatcher on Apr 30, 2010 - 10 answers

Can you help me with an Excel question?

Can you help me with an Excel question? [more inside]
posted by ersatzkat on Apr 22, 2010 - 13 answers

Hey all you apps, quit taking over my function keys!

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

Trying to find Excel VBA code for "round dot" gridline.

Excel VBA question: help me insert a "round dot" gridline in my chart. [more inside]
posted by mullacc on Apr 18, 2010 - 8 answers

Excel wizardry needed

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

How do I get a CSV file to display properly?

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

This should be simple in Excel right?

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

Excel for Business?

Quickbooks vs. Excel? My business partner needs some convincing. [more inside]
posted by pakoothefakoo on Apr 6, 2010 - 17 answers

Funnel Charts for Excel 2007?

Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
posted by thankyoumuchly on Apr 1, 2010 - 2 answers

What blogs/books should I read before creating an archival database?

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

need help organizing spreadsheet

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.

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

Excel Quest

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

Turns out our top referrer is

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

Calling all pairs

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

Excel Noobery

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

Help me so I can Wait for it... EXCEL at my job!

Help with Excel 2003... More inside: [more inside]
posted by Mastercheddaar on Mar 9, 2010 - 7 answers

Help me edit named ranges in Excel 2008.

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

Using Excel Formulas to Rank Ordered Lists

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

If I add a percentage to a number, how do I find the original again?

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 Dilemna

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

Excel: What column does this value appear in?

Excel: How can I find the column that a value appears in? [more inside]
posted by dmd on Mar 2, 2010 - 9 answers

One to Many Renaming & Copying

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

Using Excel to create the body of an Outlook e-mail

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

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

The cake is not a lie, if we know you deserve it . . .

Excel date puzzle - looking for a simpler solution, ramblings follow [more inside]
posted by protorp on Feb 19, 2010 - 12 answers

A graph for all to see.

How do I get an Excel-generated chart onto Facebook? [more inside]
posted by ricochet biscuit on Feb 13, 2010 - 7 answers

Excel rounding of number

Is there a way to force MS Excel to always give you four significant digits when rounding a number? [more inside]
posted by a womble is an active kind of sloth on Feb 13, 2010 - 6 answers

Getting Excel to reconcile two types of data

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

Can you recommend online tutorials for Excel, Word, and MS Access?

Can you recommend online tutorials for Excel, Word, and MS Access? [more inside]
posted by helios410 on Feb 10, 2010 - 8 answers

Standardize my comment size

Is there a way to standardize 'comment' window sizes in Excel?
posted by digiFramph on Feb 10, 2010 - 10 answers

How do I plot a comparison of points to the normal curve in excel?

How do I compare a scatter of points in excel to a normal curve? [more inside]
posted by jefficator on Feb 8, 2010 - 12 answers

Escelfilter: Making a dummy worksheet to simplify display of information?

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

Column-oriented CSV in Python?

Is there a simple, elegant way to iterate over columns in CSV files using Python? [more inside]
posted by Kadin2048 on Jan 11, 2010 - 13 answers

Another GD excel question

Another, once again, excel question on fill colors [more inside]
posted by TheBones on Jan 5, 2010 - 11 answers

Excel lookup same day different date previous year

Quick Excel help? Need to retrieve this day last year based on date input by user [more inside]
posted by hypersloth on Jan 4, 2010 - 15 answers

How do I bring HTML data into Excel?

I once used a web-based spreadsheet tool that let me copy data from pretty much any webpage into a properly formated spreadsheet. Upon pasting an entire page worth of HTML-formatted search results, for example, it prompted me for the desired cell arrangement in the spreadsheet and applied it to the entire set of data. I can't remember what it was called, I can't seem to google the right terms and this will save me (not to mention my employer) countless hours copying and pasting data this week and next. Alternatively if you have another solution, please share.
posted by reeddavid on Dec 29, 2009 - 10 answers

Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.) [more inside]
posted by malcommc on Dec 28, 2009 - 5 answers

Blind Spot in my Excel Formula Abilities

Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]
posted by itsonreserve on Dec 23, 2009 - 7 answers

Word 2007 formatting question

How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
posted by jujube on Dec 17, 2009 - 15 answers

I've just spent 16 hours on a lab. Never again.

What spreadsheet/graphing software should I use to do physics labs? [more inside]
posted by vogon_poet on Dec 13, 2009 - 18 answers

Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number? [more inside]
posted by JulianDay on Dec 6, 2009 - 7 answers

Need help making an excel formula

Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries. [more inside]
posted by FireStyle on Dec 2, 2009 - 4 answers

Type, copy, click, paste, type, copy, click...

I've been manually sending out emails about test results and then entering them into a database - is there a way to automate so part of this process? [more inside]
posted by SNWidget on Dec 2, 2009 - 10 answers

Slow typing in Excel 2008 and unexplained network traffic

Why would Excel 2008 cause a lot of network traffic while typing in a cell? [more inside]
posted by lbergstr on Nov 27, 2009 - 10 answers

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox

Need help developing a Excel VBA Macro to Vaildate data entered into a textbox [more inside]
posted by complience on Nov 25, 2009 - 4 answers

Page: 1 ... 4 5 6 7 8 9 10 11 ... 18