I figured maybe if you see the worksheet in person, you
might be better able to understand. Anyone interested
please post, and I can e-mail you the file. Thanks.
Greatly appreaciated.

I put in a conditional format (=$C$8<>SUM($L$8:$W$8)) and
I want to copy that formula down the sheet, but the row
numbers do not change when I copy/paste down the other
rows.  Is there a way to make the row #s change without

Good day,
I have a column with Date entries in this format "16-JAN".
Example:
16-JAN

A report groups certain account codes by default. We have a macro
(mostly built) to change this information. What we need to do is insert
a Go To or some other command that will look for the end of Column C
and not go to the end of the cells. Column C is dynamic depending on

Of course moments after I posted sumif confusion, the
formula worked.
I want to copy the formula from cell b2 to cells  b3:b30
without having the cell reference change. I can easily go

Here's my problem: I am comparing two columns of data to
calculate the percent change of each data item
(before/after analysis).  This I do with a simple delta
percent equation.  Then, I need to know what is the

I posted yesterday and read someone else's posting today
with the same (or a similar?) question but I still do not
understand how to use sumif. It seems to involve sumif
but when I tried the formula suggested, I could not get

Ok here is my issue.  I have a excel sheet that has this kind of
layout.
Name    Test 1    Test 2    Test 3    Test 4    Average
Curly    99    84    73    68    81.0

Can anyone help?  I am looking to compare to worksheets.  
Both worksheets have column labelled 'patient number' and
the number is a four digit number.  I would like to
compare the two worksheets and gather a list of patients

I have seen this question come up a couple times but I have not been
able to get the solutions to work.  Here is my problem:
I have a list of part numbers on one sheet in col. A.  In Col B I have
a countif formula that returns the total number of times that part

Please help. i have a set of TEXT in D1:D20 that I will
like to compare with in A5. And if there is a match I
want all  corresponding data (c1:c20)  total hours in
B21. I have used this formula and it gives me the

Is it possible to make multiple copies of a worksheet and
add them to the same workbook?

I have a worksheet with a bunch of data in it.  The first
row consists of student ID numbers.  The rest of it is
just information about the students.  In another worksheet
I have another column of data which I would like to insert

How can I use the column letter in a formula?
=sum(c10:ax10)
I want the "ax10" to be dynamic based on a cell value.  For example, it the
cell value is 14, I want to use the 14th column (N) in stead of "AX"

i want to extract a date from a text. for example, i have the followin
line:
"monday 1 january 1978"
"tuesday 2 january 1978"