I have ranked the times of races for 30 participants.  The results are in a
column.  I want to display the points given in the next column. The only
points given are for 1st through 6th place. 1st=6pts, 2nd=5pts, 3rd=4pts,
4th=3pts, 5th=2pts, 6th=1pt,  7th place through 30th ...

how do i get a running total from the same cell on multiple worksheets that
updats as I add more worksheets to the file
ie. i am keeping a weeks work on a new worksheet in the same file and want a
worksheet that runs totals for all the weekly worksheets and i want the

I need to define the size of the table, so that the cursor goes back to
the fisrt column, next row, when I insert data and reach the end of the
line.
Can it be done in Excel?

I suppose this should be easy; but, I have searched and searched and
can't find an answer in this group or anywhere else, so here goes:
I need to know what formula to use in my conditional formatting for a
cell such that if I find the exact text that is in the cell in a named

I have a that list part numbers accross a product line I have the formula
=SUMPRODUCT((B4:O33<>"")/COUNTIF(B4:O33,B4:O33&""))
counting the number of unique part numbers on this spreadsheet BUT now I
would like it to create in a NEW column, say R starting at R1 the list of

Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
formula, however the results do not seem correct. I even entered the sample
from Help and it did not return the result that is shown in Help. I did the
Error Checking function and it came back with no errors

Hello,
I'm hoping someone can help me.
I have a spreadsheet where I keep a tally of money owing to us. We need to
add 8% on the total each time.

Hopefully, this is the correct forum in which to ask this question.
In Cell K320, when the formula is
=K182
I get a blank (zero)

We use paging software to page people to fix problems.
The data from the paging software can be output to a spreadsheet showing a
row for every page that is sent. I would like to setup a spreadsheet to show
how many times a person is paged each day, on a monthly basis.

I have a spreadsheet that is done each day and is generated each day by
saving the spreadsheet from the day before under the current date.
In it is a figure that sums the number of hours generated that particular
day.  There is also a figure for the number of hours generated for ...

Is it possible to alter the rounding rules in Excel so that it rounds up when
the value is .5 or higher

Been searching previous post for an answer to my question, but I got
nothing.
Here's my problem:
I have two tables in two worksheets.  Fist table consists of sizes,

I hope someone can help me with this problem.
When I open Excel [or Word], the Office assistant is not visible. When I
click on  'Help' and the 'Show Office Assistant', the program crashes.
Also, in Excel, when I start a formula by pressing the "=" sign in a cell or

I have a range of cells from E18:E21 that look like this:
?
?
?3?

I need help in formatting picture graphics that will remain with my dat
line so that when I sort or filter the data the picture graphic stay
with it.  I tried the Chart embedding but that isn't what I need...
can someone help me with that