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

Excel filter:: Making mailing labels out of an excel spreadsheet? [more inside]
posted 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 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 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 on Apr 14, 2008 - 9 answers

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

How do you figure out daily interest from an APR on student loans due monthly? [more inside]
posted 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 on Jan 24, 2008 - 6 answers

Excel 2003 question -- why do some of my cells show ####### in the contents? [more inside]
posted 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 on Dec 16, 2007 - 3 answers

Question on converting numbers into formatted text with Excel. [more inside]
posted 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 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 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 on Aug 18, 2007 - 9 answers

I've done something odd to Excel. Please help! (more inside) [more inside]
posted 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 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 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 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 on Apr 25, 2007 - 10 answers

Open Office Calc and sorting data question. [more inside]
posted 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 on Aug 17, 2006 - 11 answers

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

Excel Powers Active! Vague Excel spreadsheet lookup problem inside. [more inside]
posted 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 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 on Apr 7, 2006 - 6 answers

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

Microsoft Excel help needed. [more inside]
posted 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 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 on May 30, 2005 - 6 answers

Mathematical imbecile question: what's the simplest, most universal way to add a list of vectors? [more inside]
posted on Feb 19, 2005 - 7 answers

RE: Excel: I have an Excel spreadsheet where one column is filled with dates — but the dates aren't showing up properly in the spreadsheet. Instead of looking like a date, they are flat numbers (02/29/2004 is rendered "36584" in the display) — even though the proper date is revealed in the FORMULA BAR as I select each cell. I've set the text type to DATE in the FORMAT dialog... I've even tried setting the text type to PLAIN TEXT. No go. Strangely, the numbers increment with the date (03/07/2004 is "36591"), so I'm guessing there's some equation going on. Suggestions on getting the dates to render properly would be appreciated.
posted on Jun 25, 2004 - 10 answers

Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.

One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.

The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.

Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted on May 11, 2004 - 1 answers

Dumb Excel question: How do you add rows of cells at the top of a sheet that do not scroll? We've tried Googling, we've tried the Excel help, we've tried poking around at every function that looks obvious, and a few that didn't...
posted on Jan 23, 2004 - 9 answers