I able to find the Min and Max date from a Range of Dates. However, I would
like the Min and Max date for a range of facilities -
Data
Facility 1   12/21/2005

With due respect, 2007 did include many improvements..  Faster
editing/formating, extended conditional formating, better wizards,
etc..
Be aware that some of the formating may not be compatible with 2003

I have a scorecard in Excel 2003 and instead of having DIV/0 errors
displayed is there a way of actually forcing it to display a zero/null
value? I had a looked at conditional formatting and the example only seems
to be hiding it in a different colour.

Ok here it goes.  I have recently purchased a new computer and had all the
old computer memory transferred to the new PC.  The old worked off of Windows
98SE and the new is in XP with Office.  How can I view an old document that
was done in Works (spreadsheet) on the new system?  ...

Suppose you have data 1,2,3,4,5 in cells G1-G5.
Now in A1 we have formula =G1, how can I drag into B1 to E1 to fill
with formulae =G2 , =G3 , =G4 and =G5 resp.

I have a field that sums a date plus 14 days and I am getting some very
strange results.
Any clue?

I am wondering if there is a way to have a multi-level pick list in Excel.
In other words, I have a main category as a pick list in column A, then a
more detailed category as a pick list in column B.  I would like to make it
so that the pick list in column B is limited based on ...

Thanks for reading.
I use Excel 2003 up-to-date.  I have a spreadsheet with headers in the
first 4 rows, dates in column A, and data starting in B5 - S5 across
and down to row 297.  I have frozen the pane at B5 so I can see the

I am trying to create a slide in a PowerPoint presentation fo
management featuring a stationary Excel graph and a frame within th
same slide displaying the actual Excel data set that can be scrolle
through in that frame. Does anyone know what VBA code I could use t

I have a problem with Excel.  I have a worksheet with two columns.  In
one column is a date when an event was due, and in the other, when it
was completed.  What I want to do is to easily figure out how many
items were completed after they were due.

Is it possible to create a limit on how many characters can be entered into a
cell? E.g. limiting a cell to a maximum of 25 characters.

I have some data arrnaged this way:
Name    Subject   Grade
Peter     Math         A
Peter     English      B

I am trying to create a simple line chart using the same cell (C3 in this
case) on four contiguous worksheets (Sheet1 through Sheet4) as my 4 data
points.  I have tried generating the chart using the chart wizard and
setting Cell C3 on Sheet 1 as my data series.  I then tried ...

I have some macros which I distribute as a .xla file. It works allright, but
when I run macros from the .xla Add in, it keeps opening a blank sheet from
the orignial .xls file from which the .xla is based on.
How can I hide/delete this sheet once and for all? Excel won't let me ...

could someone please help me, the problem i have is we have an excel
spreadsheet template and was wondering how to possibly setup a formula
or something to autofill the address lines after i insert the post
code, does anyone have any ideas?