964 posts tagged with excel.
Displaying 751 through 800 of 964. Subscribe:

Generate links to external files in Excel

In MS Excel, is there any way to take a cell value and use it to search A folder for a file with the same name, then add a link to it? [more inside]
posted by davehat on Nov 16, 2007 - 7 answers

Making Swedish Excel 2007 behave

How do i make Excel 2007 use Anglo-American style period (.) instead of Swedish style comma (,) as a decimal separator?
posted by ilike on Nov 13, 2007 - 5 answers

Excel copy cell CRASH. (why?)

Excel for Mac freezes on copy (command-c)! Help. [more inside]
posted by lucasks on Nov 12, 2007 - 1 answer

Question on converting numbers into formatted text with Excel.

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

Just a little bit of help with Access...

I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
posted by dance on Nov 5, 2007 - 2 answers

Help me sort out my surveys please!

i have a whole bunch of plain text emails that I would like to amalgamate into one spreadsheet. Is this possible - easily? [more inside]
posted by chairish on Nov 3, 2007 - 6 answers

Need magic to convert PDF to Excel

OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]
posted by bartleby on Oct 23, 2007 - 9 answers

Spreadsheet program with images in cells?

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

Accelerating with Excel

I have a list of a few hundred people involved with the school I am at this year, and I need to break the names into First, Middle, and Last Name. Is there a way to make excel go through a list of names and at any point where there is a character break (a space like this---> ) put the rest of the cell one over to the right?
posted by daviss on Oct 22, 2007 - 13 answers

VB in the tree

vbFilter: Outputting results to a treeview object in Excel. [more inside]
posted by dnthomps on Oct 21, 2007 - 1 answer

Help me Excel.

Please help me create an expandable excel function that can find and extract cell rows. [more inside]
posted by guruguy9 on Oct 11, 2007 - 5 answers

Excel template for daycare billing?

Looking for an Excel template to track children's time (billable hours) over a month. [more inside]
posted by OlderThanTOS on Oct 9, 2007 - 6 answers

Help me chose books for Access and Excel!

I need recommendations of some books for Excel and Access. I'm looking for something referency, but still readable. [more inside]
posted by chrispy108 on Oct 8, 2007 - 6 answers

What do I need to learn to get my trading software talking to Excel?

An Excel RTD problem [more inside]
posted by rakish_yet_centered on Sep 23, 2007 - 0 answers

Fun New Product at Work

The management at the company I'm working for has sold a couple customers on a product that we as the worker-bees have yet to produce. That being said I view this more as an opportunity to do something new than as a huge hassle, assuming we can figure out a convenient way of producing said product. So I was hoping the great and wonderful MeFi might have a couple suggestions they might throw my way. [more inside]
posted by bernsno on Sep 17, 2007 - 3 answers

Help me sort my rows please!

Is there a way to sort by "highlighted field" in Excel? [more inside]
posted by BuddhaBelly on Sep 11, 2007 - 5 answers

Excel 2007 issue.

What's wrong with my copy of Excel 2007? [more inside]
posted by phaded on Sep 6, 2007 - 7 answers

Frustration high due to Excel problem - how do I make my sorted data update in my graph?

Frustration high due to Excel problem - how do I make my sorted data update in the graph? [more inside]
posted by Carialle on Aug 29, 2007 - 4 answers

Work your Excel Wizardry

Calling Excel wizards: Splitting groceries in Excel between 3 people [more inside]
posted by craven_morhead on Aug 27, 2007 - 7 answers

Age formulas in MS Excel

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?

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

Excel String-Counting Help!

ExcelFilter: Help me count rows where one string appears in one column and a second string appears in a second! [more inside]
posted by Alterscape on Aug 14, 2007 - 5 answers

How to use counting formulas in Excel?

I need help with counting formulas in Excel! [more inside]
posted by Lilou on Aug 12, 2007 - 13 answers

How to compare multi-row averages in JMP?

How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]
posted by dmd on Jul 22, 2007 - 8 answers

Excel dragging other files into the party...

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

Applescript+Excel+Pivot Table

Applescript + Excel . How to suppress subtotals for a field in a pivot table? [more inside]
posted by cdavis on Jul 12, 2007 - 2 answers

Excel: how do I calculate the last X cells?

Another excel question...working with the last X cells in a row [more inside]
posted by underwater on Jul 11, 2007 - 11 answers

Saving Excel as A Web Page looks sooooo Ugly! Help!

I need to get a nice looking excel sheet published to the web daily. The problem: if I "save as web page" from excel it doesn't look so nice anymore as excel doesn't translate its formatting well at all, but if I were to take a screen shot and publish it as an image I lose the embedded links. What to do? [more inside]
posted by TweetleBeetleBattleBookie on Jul 11, 2007 - 8 answers

Help me make the graph my boss imagined!

Graphing question: My boss has an idea of how our data should be presented. Please help me figure out how to make it happen! [more inside]
posted by nprigoda on Jul 4, 2007 - 5 answers

Excel N00b

Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]
posted by chuckdarwin on Jul 4, 2007 - 6 answers

excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]
posted by beammeup4 on Jul 2, 2007 - 10 answers

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

Page: 1 ... 12 13 14 15 16 17 18 19 20