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

Intermediate level Excel formula question.... Say I have a column with an array of dates in order and a matching column with an array of values. I need a formula that outputs the date at which one of the values first falls below a certain number. [more inside]
posted on Aug 1, 2008 - 2 answers

Turning Excel data into an interactive, wizard-like app? [more inside]
posted on Aug 1, 2008 - 11 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 on Jul 31, 2008 - 10 answers

Can Excel 2003 sort (or filter) primarily on case? [more inside]
posted on Jul 30, 2008 - 8 answers

Excel 2007: How do I get "Sum of" out of the data headers of my Pivottable? [more inside]
posted 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 on Jul 28, 2008 - 11 answers

I have to create an excel sheet to keep track of a book budget - in the most basic terms, I will have a total budget figure, and I want to subtract invoice figures to keep a running total. Here's an example of what I want the sheet to look like: http://i109.photobucket.com/albums/n46/coollibrarian/excel.jpg The simpler the better. [more inside]
posted on Jul 26, 2008 - 7 answers

cp /mnt/com/ebay/completed_auctions/ps3 ~/ps3.txt ?? [more inside]
posted on Jul 23, 2008 - 6 answers

What's the easiest way to merge data from multiple Excel worksheets into one big worksheet [more inside]
posted on Jul 21, 2008 - 2 answers

I have created an excel spreadsheet that pulls data from the web, it works great. The only problem is that I can't tell if the data has changed over time. The website that I am pulling from doesn't track changes over time but it would be helpful for me. Is there a way to graph the data over time?
posted on Jul 11, 2008 - 5 answers

How can I export a bunch of email subjects to Excel? [more inside]
posted on Jul 10, 2008 - 3 answers

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

Within cell C2, If the content of a cell in $A$10:$A$900 is the same as the content in A2, I would like Excel to Average the contents of column H in the rows that match A2...does that even make sense? [more inside]
posted on Jul 2, 2008 - 6 answers

Why is Excel Solver not using the binary constraints I've set? [more inside]
posted on Jun 19, 2008 - 12 answers

I need help making sense of data from an adobe form that I want to export to excel. Adobe just laughs and excel simply shrugs. [more inside]
posted on Jun 16, 2008 - 6 answers

Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
posted on Jun 10, 2008 - 5 answers

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

I am looking for some good data visualisation books, tutorials and maybe software [more inside]
posted on May 29, 2008 - 9 answers

I'm looking for an easy way to find (not remove) duplicate information in an excel database. Ideally I need to be able to easily cross reference the other records with identical information in a certain column. [more inside]
posted on May 29, 2008 - 10 answers

Complicated Excel formula question involving text-search and Japanese characters. Can you help? [more inside]
posted on May 27, 2008 - 2 answers

I signed up to give a 90-minute Powerpoint presentation on Microsoft Excel 2007. It's open-ended as to the specific content, and I am stuck. [more inside]
posted on May 27, 2008 - 15 answers

Sometimes excel VBA code executes very slow. Sometimes it's really fast. I can't seem to pinpoint why. [more inside]
posted on May 21, 2008 - 8 answers

Item: one Excel spreadsheet. Contains: fifty rows. Column A - parrot name. Column B - parrot selling price. Column C - parrot age when sold. Without sorting the rows, how can I find the average age when sold of the most expensive ten parrots? I know I need an array here but just can't work out how to get my correct parrot average.
posted on May 21, 2008 - 10 answers

I have an Excel spreadsheet that contains a list of songs, and I want the viewer of the spreadsheet to be able to conveniently listen to sample clips of these songs. The 30 second sample clips are stored in MP3 format on a publicly accessable web server. [more inside]
posted on May 20, 2008 - 7 answers

Help me recreate these charts in Excel [more inside]
posted on May 20, 2008 - 8 answers

Visual Basic and Excel: How do I replicate the results of excel’s internal function for paired dual tailed t-test in Visual Basic. I tried and failed, where did I go wrong? [more inside]
posted on May 16, 2008 - 8 answers

I have no clue what I am doing in Excel, so this is going to be a bit hard to explain, but hopefully somebody can help me here. I want to give Excel some text, and have it output a string. Let me explain. [more inside]
posted on May 13, 2008 - 4 answers

Someone asked me if I could use Excel to take a table of information and put it into a new table randomly. Without thinking about it too hard I said "Yeah, I bet I could do that." Turns out I spoke too soon. [more inside]
posted on May 13, 2008 - 7 answers

How to tally votes in Excel? There is an Excel spreadsheet with many categories, with many votes per category. How do I get Excel to tally up the individual votes in a singe category? Each category is column, with the various votes per category listed as rows.
posted on May 4, 2008 - 21 answers

I'm using Microsoft Excel 2003 at work and I need to make a chart where the category (x) axis is the y axis; is there any way of doing this? [more inside]
posted on Apr 30, 2008 - 5 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

Any Excel gurus in the room? I have an Excel spreadsheet with over 800 rows of data. Each row begins with a number (like 0001), and some have letters after the numbers (like 0001a). The Sort function doesn’t sort the way I’d like it to. [more inside]
posted on Apr 17, 2008 - 7 answers

Is there a way to create a link in an Excel spreadsheet to a specific page or destination in an external PDF file? I've read some tutorials that show how to do this in html documents but can't seem to figure out if it's possible in Excel. I'm using MS Excel 2000 and Adobe Acrobat 8.1.2 Professional. Thanks!
posted on Apr 17, 2008 - 3 answers

Excel 2007 - Is there a way to remove ONLY a duplicate row leaving the first unique entry? [more inside]
posted on Apr 16, 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

Getting Excel to interpret text string as formula [more inside]
posted on Mar 29, 2008 - 7 answers

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

Excel filter-filter: How do I set up an easily adjustable filter for a 7000-odd row spreadsheet in Excel Mac 2004 or 2008? The data's not well organised and needs to be filtered over multiple columns. [more inside]
posted on Mar 20, 2008 - 5 answers

Excel for Mac - Where the hell did my comments go!!?? [more inside]
posted on Mar 14, 2008 - 3 answers

Excel help: How do I make a chart which displays my values as bars extending above and below a particular line. [more inside]
posted on Mar 9, 2008 - 12 answers

We've got Census data in Excel from the Census Bureau. We've got a state all mapped out by census tract (using the unprojected boundary files, as they don't provide the projected files). What we don't have is a way to download values from the data files into the census tracts they correspond to. Is there some way to do this that we don't know? Will we have to write a program? [more inside]
posted on Mar 6, 2008 - 9 answers

Help me automate this task involving USB-disks, Excel, HTML and maybe a batch file. [more inside]
posted on Mar 5, 2008 - 5 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

How do I convert European dates to American in Excel? [more inside]
posted on Feb 25, 2008 - 3 answers

Can I alphabetize data in Excel (or elsewhere) while ignoring the articles "the", "a" and "an"? [more inside]
posted on Feb 20, 2008 - 10 answers

How do I add x and y axis labels to a chart in Excel 2008 for Macs? [more inside]
posted on Feb 15, 2008 - 2 answers

I would like to save an Excel spreadsheet onto the desktop of a computer for people to look at, but not to modify. I know how to protect the sheet to make it read-only or to require a password to modify it, but is there any way for me to prevent people from deleting it all together? I should add that the computer on which I want to have the file is running Mac OS X. Is there a way to make a file un-deletable? It is a public computer, so it must always be logged in under the same user name.
posted on Feb 12, 2008 - 12 answers

Spreadsheet design: I have to work with an Excel workbook that is driving me nuts... [more inside]
posted on Feb 7, 2008 - 13 answers