883 posts tagged with excel.
Displaying 701 through 750 of 883. Subscribe:

Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 answers

ExcelFilter: How do I display the sum within that column without resulting in a "circular reference" error?

ExcelFilter: How do I display the sum within that column without resulting in a "circular reference" error? [more inside]
posted by chefscotticus on Jun 29, 2007 - 13 answers

Making two rows into one in Excel

AnotherExcelQuestion: Data that is in two rows needs to be in 1 row. I know it can be done manually, but I have data for 998 individuals to deal with. [more inside]
posted by SheIsMighty on Jun 22, 2007 - 10 answers

Make Excel Make Coleslaw!

Excelfilter!! Okay, how would I do this in MS Excel??? [more inside]
posted by keep it tight on Jun 21, 2007 - 6 answers

2 + 46% = ?

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

calculate average speed with a start and end time

Excel Filter: How do I calculate average speed with a start and end time? [more inside]
posted by bytewrite on Jun 6, 2007 - 7 answers

Can Excel copy text from cell in one worksheet to cell in another?

MS Excel help, please. I'm creating a multi-sheet workbook, and cells on one sheet will contain the same text as cells on another sheet. Is there a way I can avoid having to enter the text on each sheet? Is there a function that will automatically copy text from a cell on one sheet to a cell on another sheet?
posted by msacheson on May 15, 2007 - 7 answers

Excel translated w/o my permission.

Excel - automatically converted my numerical values - [more inside]
posted by seeminglyshy on May 14, 2007 - 8 answers

Help me autoimport!

Automate Excel Filter..... I am getting via email a CSV file daily that I would like to automate into excel. [more inside]
posted by keep it tight on May 14, 2007 - 4 answers

Basic MS Excel question.

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

Spreadsheet to calculate EI/CPP?

Are there Excel spreadsheets available for Canadian (Ontario) payroll calculation that automatically calculate EI, CPP, etc?
posted by Jairus on May 7, 2007 - 1 answer

How do you create text files from a spreadsheet?

How do you create text files from a spreadsheet? [more inside]
posted by bigmusic on May 2, 2007 - 6 answers

Help me prioritize the people I bug for money

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

Plaintext and Excel

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

Exce Crash

I lost all my (unsaved) work in Excel 2003 when my system did an auto-update restart without my permission. Please Help. [more inside]
posted by kevin_2864212 on Apr 12, 2007 - 4 answers

Sorting data in Open Office

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

searching for a file

Is there a way to find an excel file on your hard drive that contains a certain sequnce of digits in adjacent cells? [more inside]
posted by goethean on Mar 22, 2007 - 8 answers

Excel macro/ pivot table help

Need help coming up with a basic training/ presentation in Excel macros and pivot tables for my boss and his second in command! Can someone recommend a book- well written, concise? I use Excel a lot, had advanced training (paid for by my boss) , but I don't use macros or pivot table functions because there has been no need in my line of duty...... [more inside]
posted by mistsandrain on Mar 16, 2007 - 6 answers

How do I get my table rows to stay clumped in fives?

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

How to iterate through controls in VBA/Excel?

How do I loop through a bunch of controls using VBA in Excel 2003? [more inside]
posted by apark on Feb 22, 2007 - 4 answers

Missing commas in CSV file

Why is my CSV export missing commas, which is foiling my upload? [more inside]
posted by fijiwriter on Feb 14, 2007 - 16 answers

Manipulation of Data

Your told you have a test in Excel regarding Data Manipulation, what do you revise? [more inside]
posted by informity on Feb 13, 2007 - 11 answers

How do I remove duplicates and then merge two excel files?

In MS Excel, how do I remove duplicates, clean up a document and merge two files together? [more inside]
posted by perpetualstroll on Feb 7, 2007 - 6 answers

How to easily search/replace in MySQL database?

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted by Yavsy on Feb 6, 2007 - 10 answers

Microsoft Formula Help

How do I cut/paste a project in MS Excel and not have my formula cells change with the movement of my cells? [more inside]
posted by mi6op on Feb 5, 2007 - 4 answers

Excel mindless list jumping

Stop Excel from jumping to end of column when double clicking on cell border [more inside]
posted by clarkie666 on Jan 29, 2007 - 10 answers

Save me two weeks of manual labor, please

I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?
posted by schroedinger on Jan 26, 2007 - 9 answers

Excel formula question

Excel question: How to define a range so that it always adds up to a constant value. [more inside]
posted by corpse on Jan 16, 2007 - 20 answers

Spreadsheet Cleanout

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]
posted by moocheen on Jan 15, 2007 - 10 answers

I miss my speadsheets!

Why is Excel not opening? [more inside]
posted by thetenthstory on Jan 13, 2007 - 7 answers

How do I create PDF forms from Access/Excel data?

I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet. [more inside]
posted by elle.jeezy on Jan 3, 2007 - 3 answers

Excel help.

Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year) [more inside]
posted by brent on Dec 27, 2006 - 4 answers

Merging Excel Sheets (With a Macro?)

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]
posted by chrisamiller on Dec 27, 2006 - 3 answers

To underscore or not to underscore?

Is there an advantage to having an underscore in a file name? [more inside]
posted by pdb on Dec 21, 2006 - 23 answers

Counting challenge in Excel

Excel question: I can't figure out how to count what I want to count... [more inside]
posted by underwater on Dec 2, 2006 - 6 answers

Mailmerge Filter (how to create separate docs)

I'm doing a code review and I'm keeping track of my findngs on an Excel spreadsheet. I need to generate reports that show vital details about the source code file being reviewed. Unfortunatley, as far as I can tell, MS Word 2003 generates one Word doc that has all oft he merged content in one file. How do I get it to create separate documents? [more inside]
posted by apark on Nov 17, 2006 - 8 answers

excel/word online tutorial

My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to. Regards/p &k
posted by patrickje on Nov 16, 2006 - 5 answers

Finding the right Microsoft Excel formula

I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5. I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea? (I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit on Nov 9, 2006 - 14 answers

Cheap copy of Excel for Mac?

Where can I get a cheap copy of Excel for my mac? [more inside]
posted by bajema on Nov 7, 2006 - 9 answers

Error When Exporting Access Report to Excel

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047 on Nov 6, 2006 - 4 answers

Excel - relative vs. absolute chart time

Excel question on charting time - how to make it appear relative, not absolute? [more inside]
posted by ObscureReferenceMan on Nov 6, 2006 - 5 answers

Excel Hell

How can I open a Microscoff Excel (Macintosh) version 1 document? [more inside]
posted by TiredStarling on Oct 27, 2006 - 6 answers

Strip HTML from Excel

I have a large excel spreadsheet that contains various html tags, mainly bold and anchor tags (in upper case and lower case). How can i automagically remove them? [more inside]
posted by anonaccount on Oct 27, 2006 - 9 answers

Excel cells as input AND output?

Excel wizards: is it possible to create a temperature conversion calculator (Celsius, Fahrenheit, and Kelvin) using only 3 cells for the interface? I have the conversions and know how to do conditional formulas, but what tricks would be involved in having each cell handle both output and potential input?
posted by Tubes on Oct 24, 2006 - 15 answers

Excel: Connecting the dots between inconsistent data

Excel: I am trying to create a line graph of last year's workload versus this year's workload. Problem is, I don't have consistent data and my graphs have numerous gaps between data points. How can I best fill these gaps? [more inside]
posted by Ziggy Zaga on Oct 15, 2006 - 6 answers

My Mac(Book) Sucks

Any advice for my MacBook Word / Excel / Powerpoint woes? [more inside]
posted by roofus on Sep 29, 2006 - 17 answers

Help me optimize a list in Excel.

Help me optimize a list in Excel. (Excel gurus welcome!) [more inside]
posted by pealco on Sep 28, 2006 - 3 answers

How do I COMPLETELY turn off Excel autoformatting?

How do I completely turn off all autoformatting in Excel? [more inside]
posted by EndsOfInvention on Sep 28, 2006 - 6 answers

Help for Excel

Excel help please: Is there a keystroke for Insert->Name->Define? Can I make one? How? I use this a ton in my work.
posted by eatdonuts on Sep 25, 2006 - 6 answers

I need a fix for an excel formula recalculation error.

I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
posted by batcrazy on Sep 21, 2006 - 6 answers

Page: 1 ... 11 12 13 14 15 16 17 18