when copying a formula from one cell using the cell drag down method to the
cell below I get the value of the first cell.  I have tried using the paste
special function and following the general tips with no success.  I have
tried the method on another computer and it works, ...

I am working on a worksheet that has been imported into excel from an
antiquated mainframe and so the resulting excel worksheet carries the headers
and footer from the mainframe.  Basically, these header and footer prevent
the worksheet from functioning like a data sheet.  I want ...

I used IPMT but I'm Canadian and it doesn't work for Canada so I basically
need to do an amortization schedule and I have no clue the formulas needed to
do this manually.
I fugure you need a principle column, interest column, monthly payment column.

I've been trawling the messages for a couple of hours now and am getting more
and more confused (it's my age)
I have column A with various dates
Column B has the status "open" or Closed"

I’m trying to do a conditional:
This is the end result I’m looking for.
If cell (F1) has a text match for = CA
Then I want cell (L1) to =SUM(I1*.0875)

I have a spreadsheet that is not protected, but the row and columns do not
show up.  If you select the leftmost column the address box shows "O1" if you
scroll to the right, you will see O1, P1, then jumps to U1.  Same thing with
the rows, the spreadsheet does not display them.  ...

Lets assume I have all my dates in one column (T).  How can I count the
number of occurances I have per month.  I want a count of all dates in Jan,
Feb, etc. for that year.
My data will be setup like this:

I have set up an advanced filter, but don't seem to be able to get it to
automatically recalculate the filter when i change the number i am filtering
for in the criteris range. Is there a way i can get the filter to
automatically refresh when this criteris is changed?

I wonder if somebody can help me. I need to find a formula that finds which
cost pool split to apply to each cost pools.
Example:
Cost Pool    Cost Pool Split    Amount      A                       BBB    CA

I have several workbooks each with one worksheet.  These worksheets are all
named something different.  I want to combine/merge these workbooks into one
workbook containing all the single sheets.  I can't use the "share and merge"
because these workbooks were created separtely ...

I've seen it done - can't find how in a help topic

I have a spreadsheet with 3 worksheets (tabs).
During the course of my work I quite often copy a worksheet by CTL +
left click and dragging.
Something has changed whereby now when I try to copy a worksheet by

Let's suppose the following facts:
I have two cells, each one containing one number.
I want to make a refference of the two values that I need to view in a third
cell, separated by commas or ";" or anything else.

I want to be able to have excell look for a company's name and autfill it on
the Purchase order.  I have typed the companies names and addresses on the
bottom of the worksheet.  I have the Purchase Order at the top of the
worksheet.  I lined up the company name and the blank on ...

I could do with some help please. I want to create a game for my
Primary school class to play.
I want Excel to generate a random number( between 1 and 100) and then
for the children to enter guesses as the number and excel to return