I need to sum up survey answers from many participants. One section of the
survey have 5 possible answers a participant can select one from (answers are
the same on all rows, from left to right: 1, 2, 3, 4, 5). The user will
highlight only one answer in each row, and I need to ...

I have a plot with dates on the x-axis and numbers on the y-axis.
I am importing database data into excel in the first tab, and
referencing that data in the second tab.  The problem I run into is
that when the imported cell is blank, the reference in tab 2 displays

I just changed versions of EXCEL and now I'm using 2007 and I cannot figure
out how to change the direction of the enter key so it moves to the right.  I
know how I did it in the old version which was Tools, Options, Edit   CAN
ANYONE HELP ME ON THIS

I know the parameters you feed to the RATE function, but does anyone know
what the RATE function does internally - how does it work?
RDph

Hello from Steved
=TODAY()
My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want

How can I sum values in my third column by specifying conditions in my first
two?
e.g. Column A has values "Jon", "Max", "Mary", "Tom"
Column B has values "A" and "B".

My data is preceeded by "." up to "........" When I use the change command to
delete the ".", it also drops any leading zeros in the text. The field is
formatted as text and the data is not proceeded by a single quote.
Ex. ...01263 changes to 1263. Any ideas why this would ...

This is a variation on "returning a blank cell from a function", which
I understand you can't do.
I'm analyzing several thousand calculated cells using the Histogram
Tool from the Analysis pack.  I need to exclude several hundred of

Don't think I was clear on my last question.  Here is the table:
Bonus   
0%-22.5%    7200
22.6%-23.8%    6600

I have two spreadsheets with columns of variables.  I have a unique
identifier variable consistent in the two spreadsheets, but some columns in
the second spreadsheet that aren't in the first.  I would like to merge the
data in the extra columns on the second spreadsheet into the ...

I have an issue for index the closest date's data(cash flow). There is
my table below,
    A                         B
C                         D

Hopefully someone can help with this one.
Each week our department generates pivot reports and the naming convention
includes the date the report is generated.  For example, REPORT A will have
52 reports by the end of the year - one for each week in the year.

Let's say that I have numbers in one cell and I want this number to be
appeared like words in the other cell how can I make it?
For example I have 155 in one cell how can I make it as One Hundred and
fifty five?

I have a percentage (26.9%) that I need to compare to a table to see what
amount of bonus my group receives.
(ie 0-22.5%=$7200, 22.6%-23.8%=$6600) and so on.  So I need to be able to
return a bonus value for whenever the percentage falls.

I need assistance with a formula that will count locations within a certain
radius on a certain date.  Column A is the date, Column B is a location, and
Column C is miles away.  The current formula which is not yielding any
results is as follows: