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

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

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

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