Skip

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

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

CONCATENATE/ CATASTROPHISE

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 Zombo.com

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

Is it possible to do a global change-style in Excel?

Is it possible to automate a citation style change on an entire column in Excel, or do I need to do this by hand? [more inside]
posted by min on Nov 24, 2009 - 11 answers

Save me from my excel hell

Another GD excel/csv filter [more inside]
posted by TheBones on Nov 20, 2009 - 3 answers

MacgyverFilter: link sharing using MS Office

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

excel gets my goat sometimes

excel filter: why wont it let me have header rows below row 1? [more inside]
posted by jak68 on Nov 19, 2009 - 15 answers

Hide rows in excel if two cells match.

Please help me create an excel macro to hide rows given a certain criteria. [more inside]
posted by onich on Nov 17, 2009 - 9 answers

-6+6*6 = 25. No, that isn't right...

Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out. [more inside]
posted by andrewcilento on Nov 10, 2009 - 8 answers

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse?

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse? [more inside]
posted by schindyguy on Nov 7, 2009 - 4 answers

Excel: Incrementing Formula Row Copied Across Columns

Excel question: I need a row number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside. [more inside]
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2009 - 12 answers

Rates of success?

Statistics question: is it possible to test sets of cumulative data for significant differences in rate? [more inside]
posted by rollick on Nov 4, 2009 - 9 answers

How to return every Nth value in a column in Excel?

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column. [more inside]
posted by malcommc on Oct 26, 2009 - 13 answers

Evaluate the meaning of a string in Excel.

How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside. [more inside]
posted by nickerbocker on Oct 22, 2009 - 10 answers

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