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]
How do i make Excel 2007 use Anglo-American style period (.) instead of Swedish style comma (,) as a decimal separator?
Excel for Mac freezes on copy (command-c)! Help. [more inside]
Question on converting numbers into formatted text with Excel. [more inside]
I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
i have a whole bunch of plain text emails that I would like to amalgamate into one spreadsheet. Is this possible - easily? [more inside]
OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]
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]
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?
vbFilter: Outputting results to a treeview object in Excel. [more inside]
Please help me create an expandable excel function that can find and extract cell rows. [more inside]
Looking for an Excel template to track children's time (billable hours) over a month. [more inside]
I need recommendations of some books for Excel and Access. I'm looking for something referency, but still readable. [more inside]
An Excel RTD problem [more inside]
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]
Is there a way to sort by "highlighted field" in Excel? [more inside]
What's wrong with my copy of Excel 2007? [more inside]
Frustration high due to Excel problem - how do I make my sorted data update in the graph? [more inside]
Calling Excel wizards: Splitting groceries in Excel between 3 people [more inside]
I need to put some test score data into Excel that works with children's ages in years and months. [more inside]
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]
ExcelFilter: Help me count rows where one string appears in one column and a second string appears in a second! [more inside]
I need help with counting formulas in Excel! [more inside]
How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]
I've done something odd to Excel. Please help! (more inside) [more inside]
Applescript + Excel . How to suppress subtotals for a field in a pivot table? [more inside]
Another excel question...working with the last X cells in a row [more inside]
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]
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]
Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet? [more inside]
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]
How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
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]
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]
Excelfilter!! Okay, how would I do this in MS Excel??? [more inside]
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]
Excel Filter: How do I calculate average speed with a start and end time? [more inside]
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?
Excel - automatically converted my numerical values - [more inside]
Automate Excel Filter..... I am getting via email a CSV file daily that I would like to automate into excel. [more inside]
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?
Are there Excel spreadsheets available for Canadian (Ontario) payroll calculation that automatically calculate EI, CPP, etc?
How do you create text files from a spreadsheet? [more inside]
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]
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]
I lost all my (unsaved) work in Excel 2003 when my system did an auto-update restart without my permission. Please Help. [more inside]
Open Office Calc and sorting data question. [more inside]
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]
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]
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]