I have a worksheet with 10.000 rows, and I would like to colorize ever
other
"group" of rows. A bit hard to explain, but here is an example:
1    <-- Gray

I need a formula that would be able to calculate the distance from the start
of a code to the end of a code.  An example table is below.  The start and
end of a code is indicated in the CONT. column. (Start of first code = S1,
end of first Code = F1,  Start of second code = S2, ...

I am trying to create a form to print checks where I can key the amount of
the check (55.75) and it will fill in another field with fifty-five and
75/100.

why does =GAMMAINV(0,5;389;1) return  #NUM! ? This function is supposed to
return num only when parametres are less than or equal 0. Excel solves it
numerically, but in case it doesn't find a numeric solution, Excel is
supposed to return  #N/A error value.

Help, please...I am using Excel 2003...as a newbie...
I need to calculate (in Column I) the match for a 401(k) as follows:
Column G is compensation, H is employee contribution, and B is Date of birth
(as numbers...ie, 01011986).

I am desperately trying to learn how to use Excel and am very new and a
not a math whiz to boot. I'm probably trying to run before I can walk i
trying to use the "if" function.
All I'm attempting to do is tell a cell to provide one answer if so an

When you have a pivot table that is two or more pages long, how do you go
about ensuring that the column titles are on each page? looking forward to
your thoughts
cheers

Excel provides some help on AutoNumbeing by filling in series or using ROW
formula. Well both have negative point thar they do not update when you add,
remove or modify rows. Well, using a different kind of ROW formula given
below you can make your autonumber update when you add, ...

Hello Experts,
How would you modify this formula so that the text and ="" [blanks] in the
range of B1:B8 are ignored; thus, not producing a #Value! error?
=SUMPRODUCT((A1:A8="a")*(B1:B8))

I am working with a spreadsheet having to do with various training my staff
must have.  Some of the certificates expire after a few years, and I wanted
to enter a function so that a cell is highlighted when it is within 3 months
from expiring, so that I will know to schedule a ...

I am desperately trying to learn how to use Excel and am very new and am
not a math whiz to boot. I'm probably trying to run before I can walk in
trying to use the "if" function.
All I'm attempting to do is tell a cell to provide one answer if so and

I am designing a spreadsheet to monitor progress through levels in th
English National curriculum. Children are given a level at the end o
the year from w, 1c,1b,1a,2c,2b,2a etc up to 5a.
I am trying to convert the text eg "2a" into a value ie 7. I hav

I am having trouble ranking cells where the lowest value receives the highest
ranking.  Excel RANK function always wants to reward the highest number with
the highest rank.  What do I need to do to adjust this formula.

Why does this not work:
=SUMPRODUCT(--(CaseData!$X$2:$X$1000="Yes")*--(CaseData!$C$2:$C$1000>=--DATE(2006,1,1)*--(CaseData!$C$2:$C$1000<=--DATE(2006,3,31))))
and this does:
=SUMPRODUCT((ISNUMBER(SEARCH("Yes",CaseData!$X$2:$X$2000)))*(CaseData!$C$2:$C$2000>=DATE(2006,1 ...

I need to have 14 characters in a line that contains words.  How do I fill
the empty spaces with zeros?