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

rounding in excel

Rounding in Excel? [more inside]
posted by Rae Datter on Feb 6, 2008 - 8 answers

Using conditional formulas to sum up data in Microsoft Excel

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]
posted by korres on Feb 5, 2008 - 4 answers

Excel: finding first and last unique record

Finding and copying the first and last value, to the left of a range in excel. [more inside]
posted by corpse on Feb 4, 2008 - 6 answers

Excel, my bane, my best friend.

Can I program Excel to read a date in a cell, and when that date has passed, make Excel alert me by highlighting the cell or something along those lines? [more inside]
posted by foxinthesnow on Feb 2, 2008 - 8 answers

How can I conditionally format an entire row in Excel based upon the data in one of the columns in that row?

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted by ChasFile on Feb 1, 2008 - 8 answers

Stupid Excel Question

Excel 2003 - how can I get 2 or more xls files to open in separate windows? [more inside]
posted by doorsfan on Jan 30, 2008 - 12 answers

How to run a query in Excel 2007?

How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted by desjardins on Jan 25, 2008 - 8 answers

Multi line Text-to-column - A CHALLENGE FOR YOU!

How to "text to column" a cell with multiple lines in Excel? [more inside]
posted by keasby on Jan 24, 2008 - 7 answers

MS Excel terror

MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]
posted by ollsen on Jan 24, 2008 - 4 answers

Photo Directory in Excel

I'd like to create what amounts to a photo directory in Excel, and be able to sort by last name. Is this possible? If so, how? [more inside]
posted by uvaleg on Jan 24, 2008 - 6 answers

This would be a perfect job for an intern. If I had one.

MS Excel filter: I'm editing a huge spreadsheet and Excel doesn't like my zip codes. How can I quickly fix this? more after jump... [more inside]
posted by LiveToEat on Jan 24, 2008 - 9 answers


Excel 2003 question -- why do some of my cells show ####### in the contents? [more inside]
posted by crapmatic on Jan 22, 2008 - 26 answers

Excel texbox madness.

I'm an Excel idiot! Why won't my text boxes show that they have a solid fill? [more inside]
posted by Thin Lizzy on Jan 19, 2008 - 3 answers

help with excel 'paste special'

excel n00b question: why is paste special not working for me? [more inside]
posted by emmatwofour on Jan 18, 2008 - 5 answers

Help me with Excel, please.

Can someone help me come up with an Excel formula? I have a column, and each row in the column has a 9 or 10 digit number. I want to apply a formula that will recognize only those numbers with 9 digits and when one is discovered, it should place a "0" in front of the number to make it a 10-digit number. I will explain why inside. [more inside]
posted by foxinthesnow on Jan 16, 2008 - 7 answers

I know there is a way to do this! There HAS to be!

MS Excel question: Creating a master spreadsheet that dynamically updates when information is updated from any one of six other spreadsheets. Possible? [more inside]
posted by Diskeater on Jan 13, 2008 - 6 answers

How do I make my Excel equations pretty?

Is there a way to format equations in Excel so they are more readable? [more inside]
posted by bchaplin on Jan 13, 2008 - 10 answers

How can I get the USDA's nutrition data into excel?

How can I get data from the USDA's food database into excel? [more inside]
posted by Nish ton on Jan 5, 2008 - 8 answers

In need of *easy* method for tracking multiple sources of income.

I want to simply my recording-keeping. Seeking an *easy* method for tracking multiple sources of income. [more inside]
posted by mintchip on Jan 2, 2008 - 8 answers

Please save me from "Excel Hell"

I need suggestions for an application (or database) to help my employer keep better track of live-trivia scorekeeping results. They are currently doing it all in various separate Excel spreadsheets, and this is (almost) 2008, so I'm sure there must be a better way. [more inside]
posted by jmnugent on Dec 24, 2007 - 3 answers

complex dice probability make head esplode

I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below. [more inside]
posted by DetonatedManiac on Dec 21, 2007 - 7 answers

Cleaning up imported data in excel using VBA.

Cleaning up imported data in excel using VBA. [more inside]
posted by corpse on Dec 21, 2007 - 1 answer

How can I round prices in Excel?

In Excel 2007, I need advice on how to round a series of prices to either a $0.50 ending, or a $0.95 ending. [more inside]
posted by Futurehouse on Dec 20, 2007 - 10 answers

Eliminating Hyperlinks in Excel X for Mac?

Probably ridiculously obvious Excel question: how do I set it so that a URL is never turned into a hyperlink? [more inside]
posted by Dreama on Dec 19, 2007 - 7 answers

How do I cut and paste in Excel?

How do I format the cell in Excel so that when I cut and paste a series of data derived from a formula onto a new sheet, it pastes the numbers, and not the formula? [more inside]
posted by jujube on Dec 19, 2007 - 7 answers

It would be easier to just assume I'm not saving enough for retirement...

Excel/OpenOffice: How can I use XIRR to show an estimated percentage return based on account deposits/withdrawals/balances? [more inside]
posted by spacewrench on Dec 16, 2007 - 3 answers

Is there such thing as an Excel formatting template thingie?

Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
posted by kmtiszen on Dec 12, 2007 - 4 answers

How to best manage a physical mailing list?

How to manage an unwieldy mailing list (for physical mailing) on a Mac. [more inside]
posted by LongDrive on Dec 12, 2007 - 3 answers

MS Excel going slow on me - Is my document too big?

Very average PC user here. The MS Excel document I use everyday has become huge over time. One sheet with 6 columns going down more than 4000 lines. It weighs 7,6 Mbyte. Too much? [more inside]
posted by amusem on Dec 11, 2007 - 10 answers

merging docs in Excel?

How to merge two docs in Excel? [more inside]
posted by Ollie on Dec 11, 2007 - 7 answers

StatisticsFilter: Correlation over time?

If I'm looking at existing statistical data, how do I try to find a correlation between two variables over time? Scatterplots have confused me, because they don't seem to reflect the passage of time, but just where x and y meet. Pearson's r doesn't seem to do it either w/r/t time. [more inside]
posted by trondant on Dec 11, 2007 - 13 answers

Creating a personalized form letter

Help me create custom documents out of pre-written paragraphs in Word. [more inside]
posted by bove on Dec 7, 2007 - 5 answers

What book will help me develop mad excel skillz?

What are the most important excel skills to have, and what book should I get that has them all? [more inside]
posted by Autarky on Dec 6, 2007 - 14 answers

Excel into MySQL..How?!

I've been trying to get a 600 record Excel database into MySQL, and failed at every turn. There must be a way! [more inside]
posted by lemonfridge on Dec 5, 2007 - 15 answers

Names as data labels or markers in Excel 2007?

Excel 2007 charting: Can you tell me how to use the name of a point as the data marker or the data label in an X-Y scatter plot? [more inside]
posted by muhonnin on Nov 28, 2007 - 4 answers

Innovative uses for Excel to improve life?

How can I use Excel to improve my life? [more inside]
posted by giggleknickers on Nov 26, 2007 - 9 answers

Excel Sheet Lockout

I have a spreadsheet that I want to lock after a certain amount of data is entered. It needs to be an auto lockout as I cannot count on the user to stop entering data after a certain point. MI [more inside]
posted by lampshade on Nov 23, 2007 - 2 answers

Excel: How to select a cell based on current month

Excel Filter: Selecting a cell/row based on current month. [more inside]
posted by shinynewnick on Nov 23, 2007 - 5 answers

Automator workflows for Excel

Automator as an antidote to Excel tedium. Can you help me get through repetitive tasks with favorite Automator tricks in Leopard? [more inside]
posted by lackutrol on Nov 18, 2007 - 6 answers

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

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