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

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

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

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

Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...] [more inside]
posted by The Deej on Aug 11, 2009 - 14 answers

How do I create an inventory database using Excel? [more inside]
posted by Seeba on Jul 14, 2009 - 10 answers

I'm looking for a randomized list of every nation state in the world, preferably in spreadsheet column form. Is there anything like this?
posted by billtron on Jun 29, 2009 - 8 answers

ExcelFilter: I want to calculate an average food spend, but the days I buy food are irregular throughout the month. How can I draw up a table/graph that gives an average based on a date and amount (for OpenOfficeCalc)? [more inside]
posted by Gisela on May 21, 2009 - 11 answers

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

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

I need to create a database in Excel, with clickable column headers (clicking on them will sort by that column). More inside, of course. [more inside]
posted by Rubythursday on Feb 4, 2009 - 7 answers

I need some help finding/creating a Calc/Excel formula that will help me track my breaks at work, depending on how long I work per day. [more inside]
posted by Solomon on Dec 18, 2008 - 7 answers

I have a very large MS Excel spreadsheet in Mac Office 2008 (yuk). I want to find every cell that contains bold text and append an asterisk to it -- i.e. "bold cell text" becomes "bold cell text*". I can probably find a Windows machine if necessary. How can this be done automatically?
posted by beniamino on Nov 2, 2008 - 4 answers

How do I export email messages from Outlook into Excel (or CSV) while retaining the date/time stamp on each message? [more inside]
posted by geekgirl397 on Oct 29, 2008 - 4 answers

I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind. [more inside]
posted by Jackie_Treehorn on Oct 24, 2008 - 9 answers

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]
posted by niles on Oct 20, 2008 - 7 answers

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers

Help me set up an Excel spreadsheet to track my gas mileage on my car. [more inside]
posted by rossination on Aug 6, 2008 - 6 answers

I'm a quick learner of computer programs... but am currently looking for a job and am realizing that I need excel training... (another of the things I really should've studied in college.) Any recommendations on where to get training in New York City? [more inside]
posted by J.R. Benedict on Jul 31, 2008 - 11 answers

Excel 2007: How do I get "Sum of" out of the data headers of my Pivottable? [more inside]
posted by skryche on Jul 28, 2008 - 4 answers

I think I'm going to start tracking my finances using Excel, or maybe Google Docs. This will supplement my credit union's online banking; I've considered Mint, Wesabe, iBank, Moneydance, among others, but haven't been impressed. Info includes date, transaction description, amount, balance, category (withdrawal, deposit, etc.), tags (gas, groceries, etc.) My question: what are your best tips, tricks, and hints for doing this? Excel formulas, creating charts, formatting technique, automation. Anything in that vein would be great. Thanks in advance!
posted by jroybal on Jul 28, 2008 - 11 answers

How can I make readable Word tables out of a large Excel spreadsheet? [more inside]
posted by lunchbox on Jul 6, 2008 - 7 answers

Excel filter:: Making mailing labels out of an excel spreadsheet? [more inside]
posted by ThomThomThomThom on Jun 4, 2008 - 4 answers

I want to take an Excel spreadsheet and just make it a dynamically sortable table I can put in a webpage or blog. I want people to be able to click a column, and have the table be sorted by that column. Best solutions? Also, if the table included locations, is it possible to make them selectable, and have the selected locations display on Google maps? Thanks.
posted by Malad on Apr 26, 2008 - 5 answers

I need a solution which will help me work out my revision plan automatically (Possible Excel filter?) Please help! [more inside]
posted by edbyford on Apr 15, 2008 - 3 answers

Excel Filter: I can't figure out how to make Excel show my budget the way I need it to. [more inside]
posted by stormygrey on Apr 14, 2008 - 9 answers

Is there a way to automate this very tedious spreadsheet task? [more inside]
posted by [expletive deleted] on Mar 24, 2008 - 14 answers

How do you figure out daily interest from an APR on student loans due monthly? [more inside]
posted by johnofjack on Feb 28, 2008 - 8 answers

I'd like to create what amounts to a photo directory in Excel, and be able to sort by last name. Is this possible? If so, how? [more inside]
posted by uvaleg on Jan 24, 2008 - 6 answers

Excel 2003 question -- why do some of my cells show ####### in the contents? [more inside]
posted by crapmatic on Jan 22, 2008 - 26 answers

Excel/OpenOffice: How can I use XIRR to show an estimated percentage return based on account deposits/withdrawals/balances? [more inside]
posted by spacewrench on Dec 16, 2007 - 3 answers

Question on converting numbers into formatted text with Excel. [more inside]
posted by Optimus Chyme on Nov 7, 2007 - 5 answers

I'm looking for a spreadsheet program for OS X that will allow me to essentially create a dictionary list, in alphabetical order... the crucial element is that it needs to be able to contain images in the cells (some definitions have diagrams)! [more inside]
posted by Yiggs on Oct 23, 2007 - 9 answers

I need to put some test score data into Excel that works with children's ages in years and months. [more inside]
posted by chairish on Aug 25, 2007 - 5 answers

What is a good user / "client-side" alternative to using the Internet Explorer right-click "export to Excel" feature? [more inside]
posted by NikitaNikita on Aug 18, 2007 - 9 answers

I've done something odd to Excel. Please help! (more inside) [more inside]
posted by Savannah on Jul 15, 2007 - 2 answers

I need some really REALLY basic spreadsheet help. I've been given the task of creating a spreadsheet that will work out for us several things - how many orders we need in total and per week, how much revenue this will bring, etc. I've got most of it worked out, but I can't for the life of me how to work out percentages. Yes, I did Google this before asking. :D [more inside]
posted by Solomon on Jun 16, 2007 - 8 answers

Basic MS Excel questions. How do I ask for the numeric value of the Nth cell to the right of the cell with this (requested) function in it? Relatedly, is there a way to write a function in some cell that places a numeric value in a cell N cells to the right of that cell?
posted by Mr. Justice on May 9, 2007 - 3 answers

Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]
posted by ewiar on May 1, 2007 - 6 answers

MS Excel: I need to place quotation marks around the numbers in a column. Is there a better way to do this than I am currently trying or is there a plaintext spreadsheet editor that would be a better solution? [more inside]
posted by imposster on Apr 25, 2007 - 10 answers

Open Office Calc and sorting data question. [more inside]
posted by Eekacat on Mar 26, 2007 - 6 answers

I run a computer service. I have an issue that is a bit outside the bounds. I have a client who has been using an Excel spreadsheet to track his portfolio. It is pre-formatted for him to enter data and the formulas are all there. Just recently, it started calculating some things incorrectly. The person who originally set it up just passed away earlier this year. We need an Excel expert that can look at the file and don't know where to begin to find one. Checked the local community college but no dice. All ideas or pointers are appreciated.
posted by titans13 on Aug 17, 2006 - 11 answers

Way to automate string creation from values in an Excel spreadsheet? [more inside]
posted by mhaw on Aug 5, 2006 - 6 answers

Excel Powers Active! Vague Excel spreadsheet lookup problem inside. [more inside]
posted by brettcar on Jul 21, 2006 - 8 answers

How can I easily get all the music files on my computer listed on to an excel spreadsheet? [more inside]
posted by Todd Lokken on Jul 21, 2006 - 9 answers

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers

ExcelFilter: How do I convert a column of names formatted Smith, John into John Smith. Feasible?
posted by furtive on Feb 9, 2006 - 8 answers

Microsoft Excel help needed. [more inside]
posted by teem on Jan 11, 2006 - 11 answers

Using MS Excel 2002 (Win), my mom has managed to reverse the order of the columns at the top of the page (Z to A instead of the usual). _Not_ the actual cell entries, but the columns themselves appear in reverse order. She has no idea how/when she did it. [more inside]
posted by rexruff on Nov 11, 2005 - 3 answers

Is there some way to link an Excel spreadsheet and Word document such that a portion of the Word document will update automatically from changes in the Excel file? [more inside]
posted by nelleish on May 30, 2005 - 6 answers