##
953 posts tagged with excel.

Displaying 701 through 750 of 953. Subscribe:

## rounding in excel

Rounding in Excel? [more inside]

## 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]

## 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]

## 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]

## 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]

## Stupid Excel Question

Excel 2003 - how can I get 2 or more xls files to open in separate windows? [more inside]

## 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]

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

How to "text to column" a cell with multiple lines in Excel? [more inside]

## MS Excel terror

MS Excel terror. Data saved but it is still gone. Where - if anywhere? [more inside]

## 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]

## 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]

## Octothorpeia

Excel 2003 question -- why do some of my cells show ####### in the contents? [more inside]

## Excel texbox madness.

I'm an Excel idiot! Why won't my text boxes show that they have a solid fill? [more inside]

## help with excel 'paste special'

excel n00b question: why is paste special not working for me? [more inside]

## 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]

## 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]

## How do I make my Excel equations pretty?

Is there a way to format equations in Excel so they are more readable? [more inside]

## 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]

## 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]

## 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]

## 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]

## Cleaning up imported data in excel using VBA.

Cleaning up imported data in excel using VBA. [more inside]

## 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]

## 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]## 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]

## 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]

## 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]

## How to best manage a physical mailing list?

How to manage an unwieldy mailing list (for physical mailing) on a Mac. [more inside]

## 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]

## merging docs in Excel?

How to merge two docs in Excel? [more inside]

## 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]## Creating a personalized form letter

Help me create custom documents out of pre-written paragraphs in Word. [more inside]

## 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]

## 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]

## 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]

## Innovative uses for Excel to improve life?

How can I use Excel to improve my life? [more inside]

## 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]

## Excel: How to select a cell based on current month

Excel Filter: Selecting a cell/row based on current month. [more inside]

## 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]

## 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]

## 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?

## Excel copy cell CRASH. (why?)

Excel for Mac freezes on copy (command-c)! Help. [more inside]

## Question on converting numbers into formatted text with Excel.

Question on converting numbers into formatted text with Excel. [more inside]

## 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]

## 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]

## Need magic to convert PDF to Excel

OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]

## 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]

## 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?

## VB in the tree

vbFilter: Outputting results to a treeview object in Excel. [more inside]

## Help me Excel.

Please help me create an expandable excel function that can find and extract cell rows. [more inside]