Does anyone know exactly how/when Solver uses the parameter constraints?  
When I ask Solver to find the value of x for which f(x)=0 subject to the
constraints that x>=L and x<=U, I always assumed that Solver would never try
to evaluate f(x) at values of x outside of the interval ...

I have an excel spread sheet into which serial numbers are input. However a
serial number can be duplicated, how can i stop this from happening.

Hi. I have a huge spreadsheet (~20,000 rows). I need to average every 48 rows
into one value. Is there a quick and easy way to do this without scrolling
through all 20,000 rows and copy-pasting the "average" function every 48th
row?

I am trying to conditional format a sheet.
There 5 different formats I would like to use:
Red fill with black text
Red fill with bold blue text

I have a pivot table with road number, house number and for my data against
this a count of occurrences. I can then select either the different road
names to look at a specific address. Is there a way i can select a a number
from the totals columns ie 4 or above to just show the ...

I created a worksheet with a background. It looks great, but when I print the
backgroung doesn't show up. Is it possible to print a document with a
backgroud picture? I'm using excel version 2003

Is there a 'Cell Format Bar' that allows you to view the cell formats.
Something similar to the formula bar but for cell formats

check spelling automatically as you type by displaying wavy red underlines
Is that possible in Excel 2003
is there any thing  ,that can make that happens
And if not,does this feature supported by Excel 2007

I am new to excel and there are several macros that I would to
delete.  How can I open existing Macro and then delete it, step by
step?

How would I associate separate colors to each of the values in my drop down
list so that when I choose the value, the color shows for the selection?
In process (yellow); Completed (green), Never Started (Red), Follow Up (Blue).
Thank you in advance.

My text tells me to start off with a plank worksheet.  Tools menu--
Macro command--Record a Macro. Up comes Record Macro Dialog Box. Name
Macro--Select a short cut key. Store Macro in "The Workbook" drop
down. O.K. to Record Macro.  Then Stop Recording Toolbar Should

I use Excel to do Sudoku puzzles. In the process of doing this I have
produced an Excel spreadsheet that calculates incorrectly. I cannot post the
file here but I will email it if anyone is interested.

I would like to create a drop down list from another worksheet in the Same
workbook and need to select the same while creating validation list.
I know we can create using a name given to the list in another worksheet and
then use it as reference in validation window. We can create ...

Thats the question, I have a pivot that I want to count the total number of
unblank fields, there are about 10, but it takes the sum and shows like 300
in grand total. I need the grand total to say 10. Is this possible? I need
this because of data replication.

I need to measure the performance of a service.   I have to time how long it
takes for series 502 from OPEN to ASG.  I wouldn't be a problem if I had the
data from the same series in the same row, but it is not the case.   I will
have the OPN time in row 2 and the ASG time in row ...