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

## =(pulling my hair out + gah!)

Excel for Mac - Where the hell did my comments go!!?? [more inside]

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

## A little knowledge is a dangerous thing

Help me automate this task involving USB-disks, Excel, HTML and maybe a batch file. [more inside]

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

## How to get Excel to convert dates from European to American

How do I convert European dates to American in Excel? [more inside]

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

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

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

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

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