I am using date-times as the x axis. The differences between two point is not
always the same. Could be 3 days, 8 days etc. But the data axis formats are
in day order day 1, 2, 3, 4 etc.. I can't seem to modify teh axis format
correctly to get what I need.  What format option can ...

I have a cell containing text.  I need a formula that takes the text and
finds an exact match in a row and return the column no.
Eg
Find Text: Name3

I have a working formula currently:
{=AVERAGE(IF($B$20:$B$50=$C17,K$20:K$50))}
However, range K20:K50 can have the error "#DIV/0!".
How do I update my formula to still average my criteria (in this case,

I just want to delete the cells and shift to the left but it doesn't
give me that option.  Why?

I've this annoying problem in Excel 2007 that doesn't exist in 2003.
When I use Format Painter, it is appending conditional formatting rules to
the cell rather than over-writing them.  How do I stop this behavior?

In my checking-account spreadsheet, I have
  A4 and below - date
  E4 and below - deposit amount
  H4 and below - comment

I have a problem with SUMPRODUCT. If I use this function:
=SUMPRODUCT($I$58:$I$108;OFFSET($H$58;58-ROW();0;51;1))
I get #VALUE! error.
But if I calculate

when i type =risknormal(0,1),it should be have a value.But when i enter, it
out #value.

This one is getting the better of me, even though I know I should be
able to figure it out myself!:
I have two columns of data: B and C.
I have one column of ID#: A

Thanks for your replies.I have an Excel application to which I provide
data through a saved query from a table in Oracle DB.I actually pull
all the rows of a field,Roc from the table into a column in excel.
Everyday,I get a data dump from an external excel sheet containing TIN

When I come out of any spreadsheet and go into any other, or the same one
again, I get a message "Error Register Base Type Library" and I have to
close down all spreadsheets and reopen them. How can I fix this?

I am trying to rank a list of 10 numbers and I know how to rank using
the RANK function. I have a problem though. When there are two (or
more) values that are the same, i want them to show .5 instead of
multiple 4s. i.e.

I want to use a formula without a function so the word
"VALUE" doesn't print out. (Invoice)
I multiply 10 rows of 2 colums, say C and H.
C is quantity and H is price.

What are some good books for someone new to spreadsheets?