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

Help me tame the Advanced Filters!

Excel filter-filter: How do I set up an easily adjustable filter for a 7000-odd row spreadsheet in Excel Mac 2004 or 2008? The data's not well organised and needs to be filtered over multiple columns. [more inside]
posted by Magnakai on Mar 20, 2008 - 5 answers

=(pulling my hair out + gah!)

Excel for Mac - Where the hell did my comments go!!?? [more inside]
posted by fillsthepews on Mar 14, 2008 - 3 answers

Name that Chart!

Excel help: How do I make a chart which displays my values as bars extending above and below a particular line. [more inside]
posted by arcticwoman on Mar 9, 2008 - 12 answers

How can we make a map with MapPoint and the Census Bureau?

We've got Census data in Excel from the Census Bureau. We've got a state all mapped out by census tract (using the unprojected boundary files, as they don't provide the projected files). What we don't have is a way to download values from the data files into the census tracts they correspond to. Is there some way to do this that we don't know? Will we have to write a program? [more inside]
posted by deejay jaydee on Mar 6, 2008 - 9 answers

A little knowledge is a dangerous thing

Help me automate this task involving USB-disks, Excel, HTML and maybe a batch file. [more inside]
posted by Iteki on Mar 5, 2008 - 5 answers

It's got an awesome appetite: Tyrannosaurus Debt

How do you figure out daily interest from an APR on student loans due monthly? [more inside]
posted by johnofjack on Feb 28, 2008 - 8 answers

How to get Excel to convert dates from European to American

How do I convert European dates to American in Excel? [more inside]
posted by jdruk on Feb 25, 2008 - 3 answers

How to alphabetize a list while ignoring articles?

Can I alphabetize data in Excel (or elsewhere) while ignoring the articles "the", "a" and "an"? [more inside]
posted by Burns Ave. on Feb 20, 2008 - 10 answers

StupidExcelQuestionFilter: Adding x and y axis labels

How do I add x and y axis labels to a chart in Excel 2008 for Macs? [more inside]
posted by peacheater on Feb 15, 2008 - 2 answers

protect my file!

I would like to save an Excel spreadsheet onto the desktop of a computer for people to look at, but not to modify. I know how to protect the sheet to make it read-only or to require a password to modify it, but is there any way for me to prevent people from deleting it all together? I should add that the computer on which I want to have the file is running Mac OS X. Is there a way to make a file un-deletable? It is a public computer, so it must always be logged in under the same user name.
posted by foxinthesnow on Feb 12, 2008 - 12 answers

I'm getting motion sickness at my desk.

Spreadsheet design: I have to work with an Excel workbook that is driving me nuts... [more inside]
posted by ohdeanna on Feb 7, 2008 - 13 answers

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

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