Need to create a constraint in Excel Solver where the sum of all investments
into an IT project does not exceed a certain % of the total capital budget
for a 5 year period.

Hello all. Please help me with a problem I am having. I have set up a
spreadsheet with 11 worksheets for keeping scores of 10 different events.
Sheets 1-10 are scores for individual events. Sheet 11 is a list that keeps
track of the top 3 in each category.

....or me
I have a formula and when I either copy and paste it the formula tries to be
"smart" and changes the reference cels.  I want to just copy and paste it
with out it trying to change anything.

How do I calculate the end date (for example of a contract) if I have the
start date and # months when the number # is not always a whole integer?

I have an excel program to enter payroll information, with individual
employee information on a separate worksheet.  When I enter salary
information on one of the worksheets, it copies to the other worksheets.  I
know how to make that happen, by clicking on each tab at the bottom ...

Dynamic Named Range "Results" spans 5 Columns and many Rows.  Each cell
houses numeric single-digit or double-digit values.
I would like a Formula to find / match all instances of any two particular
numbers (single-digit / double-digit) in the same Row and Sum the Count of

I have a spreadsheet for calculating the pivot points on stocks,
screenshot of which can be seen 'here
(http://img237.imageshack.us/img237/5785/pivots4cq.gif)
The problem with it is I have to scroll side to side to find the stoc

I am doing some mortgage calculations.  Based on any number of variables and
calculations the final payoff date can vary.  I have a spreadsheet with the
date (in mmm-yy form) in one column and another with the remaining amount on
the mortgage (which is a negative amount until ...

Example:
My sheet needs to insert a blank row under a number everytime it changes.
The column "C" may have 20 or so rows with the number 10 for example, the
next five might be the number 8, I need a row between the last number ten and

I have a multi-worksheet workbook and I would like to apply format changes to
all worksheets with a macro.  Is this possible?

How do I create a data table into Excel that shows varing interest rates and
how they would affect the payments? I am using Excel Professional.
Thanks,
TJ

Can you help me?  I am trying to make a master sheet that can be duplicated
into another sheet, when the master is changed the other sheets with it?
The version I'm using is office 2000
Thanks

I'm a relativley inexperienced excel user, and am having trouble usin
multiple criteria for a countif function. I've looked through two book
and the FAQ here, and am striking out (seems simple, so I know I'
missing something easy).

I there a way to look in one column with values like 6292, 266, 3885, 96,
47... then compare the last two digits from a cell with those in an array?
Example:
C                             K        L

Why is:
=SUMPRODUCT(--(F1:F5={2,3,4,5}))
equivalent to the number of times 2,3,4, or 5 occur within the range??
thanks,