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

Can I download only OpenOffice Writer? [more inside]
posted by ptsampras14 on Jun 18, 2009 - 4 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'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 by Rustbeard on Apr 30, 2008 - 5 answers

I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
posted by panoptican on Feb 8, 2006 - 18 answers

Microsoft Excel. Is it possible to insert some "alarm" function that will notify me if I insert duplicate text in later cells? [more inside]
posted by Amizu on Dec 7, 2005 - 4 answers

EXCEL FILTER: I have an entire column of 12 digit numbers with dashes (X-XXXX-XXXXX-X-X) and I need to delete the first five digits (and two dashes) so I can sort the numbers starting with the sixth digit. Is this possible? (more inside) [more inside]
posted by Slack-a-gogo on Jan 7, 2005 - 5 answers

I have an Excel document listing dates times and other information. I'd like to import this "calendar" to iCal but cannot figure out to get the information imported properly. I found this tool, but couldn't get it to work. I also found this application, iCal Maker but it doesn't seem to work either. Anyone have an idea on how to import a bunch of events listed in an Excel document to iCal? [More Inside] [more inside]
posted by pwb503 on Dec 19, 2004 - 0 answers

I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?
posted by bonehead on Aug 19, 2004 - 10 answers