I need to get the current worksheet name into a cell.
Each worksheet is a number (eg 1,2,3,4 etc)
Two reasons:
1. So ppl can see which worksheet they are looking on

I have a column of data that is mm:ss . I am wishing to have Excel Average
the times. I have had no suceess by formating the column as mm:ss and then
performing the function. I countunualy get the result of #DIV/0!.
Note: I am using Office 2000

I am trying to make time sheet that would forecast employment cost.
Payment criteria is that overtime applies after midnight.
Sheet that I've designed has four columns per day IE. start & finis
time for AM shift IE. (08:00 - 16:00) and start and finish for P

I would like to add more than 30 cells and place that value in another cell.  
I am being stymied at present by the limit of 30 arguments to a function.  At
present, i must split the calculation, and then pick these split values and
tie them into my result cell.  I know that this ...

Hey, I have excel 2000 and here's what i'm making and what my problem
is:
basically, i'm trying to collect a certain amount of money in a certain
amount of time :) and i'd like to make it so it calculates how much i've

In Excel, I want to add from an array a 2 condition set of figures, all
numbers above zero and only 'one per order number' so the value is not
repeated, at the same time?

I'm working with three cells:
-original $ amount
-new $ amount (original+change)
-change (new-original)

In my worksheet I have numbers in cells C7 - L35.  Is there a way to equally
increase all the values (which are different) without re-keying each one by
hand?  I don't know if I should be looking for a formula some sort of
formatting.

Is there a way to count cells that contain formulas, but only those cells
that return a value. I tried using COUNTA...but that sees the ceel as
nonblank also.

I have a spreadsheet of data set up in excel something like this
              UK        France      Spain
5kg         5.00       10.00       15.00
10kg       6.00       12.00       16.00

I am trying to create a formula that will read a range of credit card numbers
and separate out M/C and Visa, then look at the amount in the corresponding
line different column, and put the total into a given spot for visa and
another spot for M/C.

I ran out of room on my first checkbook register version 1. So I downloaded
another putting in date /continued/amt./balance then put in my next item an
it wouldnt do the math. So I cut an pasted to first register an it still
didn't do the math. Why? Help!  Thankyou

Hello, I have been given a rather large database sheet in Excel and some of
the line records have been coloured red, green and standard black. Is there a
way I can sort the records by colour i.e. red first the green then black?
Any tips or ideas most welcome Thanks Martin

i need to write a statement in excel that will copy dates to another
spreadsheet in the correct cell based on the dates and also i need it to move
down a row once the 1st row is full.
I am very new at writing statements so any help would be great.

Sorry to be such a bother to everyone...need one last formula.
I need to sum a Column when it meets Three conditions.
When the date is the same as "a189", when there is a value in a cell in
column "C" and there is also a value in column "O" (both the values in column