I would like to set up a variable range that I can use in a chart.
I am tracking five columns of data that I add to every day.  I would like to
track the most recent three weeks in a chart.  
I am thinking that this should be do-able using some variation of the offset

I want to calculate the sum of a column, for example the sum from A1 to A10
which is the function =sum(A1:A10). But instead of A10 which identifies the
last cell of the sum, I want the row number to be taken from a function that
returns an integer number. Thus, the last cell of ...

I copied some data from a report on a web page into excel.
The numbers have a " and a space in front of them, the dates have a ^ in
front.  I tried find and replace and it didn't find these symbols.  How can
I remove these?  They are making my formulas not work because excel ...

I Manually add the date in the first column, and then I have a formula
that adds all of the figures for that day, =SUMIF($A$1:$A
$1004,"=01/01/01",$C$1:$C$1004)
Is there any way that I can change this so that the formula reflects

Hi there,
I have a question about the "cell reference" in Excel.
I wonder why Excel doesn't pick up the cell reference that I enter in my
fomula

I want to do this so when i roll over the cell the comments appear on the
left hand side of cell instead of the right.

I am needing to calculate the hours (with decimal portion) between two times
spanning two or more dates
e.g. the time between
2/4/2007 3:00 am        2/5/2007 7:45 pm

i'm having the following data thru A1:C11
what i want is the sum of amt between a
given period but not equal to some codes!
for example

Hello experts,
I'm trying to use the isBlank() function to in one cell to reference
another directly to the right.
Problem is, however, that said cell to the right, while holding a null

Hi
In one column I have a list of regristion numbers that I have sent marketing
letters to for a particular month. in another worksheet I have a list of all
the vehicles that have visited us since the batch of letters were sent:

When I try to modify the text color by using RBG.  Excel change the
color in colorindex that is not the color I need.
Is any way exist to achieve this goal.

I have several Documents. For example one is called Budget 2007, Budget
2008. In each of these I have worksheets for each month, Jan, Feb, etc... I
also have a worksheet called Year. In the Year I have cells that reference
the month worksheets. For example I might have =Jan!$B23

Sorry for the confusing title....I couldn't figure out another way to say it.
But I can't figure out which formula to use for this.
For example:
Workbook 1 - contains 2 worksheets

How can I delete all empty cells from a range of 5000 cells?

I have an excel file that contains text cells which need to be formatted to
dates some are single digit months and some are double digit (3042006
11051999 1012001) etc.  I need to figure out how to convert these dates into
a standard date format.  I am importing them into my ...