Is it possible to have more than thirty arguments in a single average
function? The arguments are not contiguous, so i can't just make them into
data points...
What should I do?

I made an annual leave workbook  for all employee each one has his own
sheet with his own records and total
Ex : From=A2         TO=B2             C2= Total
      01/01/2008       02/01/2008       2 DAYS

Been trying to figure this one out...
I track several parameters month/quarterly/annually in this fashion:

Oct | Nov | Dec | Q4 | Annual |

When one clicks on the office button, a window pops up showing a long list
of previous opened Excel files. I would like to delete those items that
reference a CD drive. How do I do that?
ed

excel version 2003
If I change a number in a column that I have totaled, how do I update the
total value without haveing to click on the total and then hit the F9 button

I am trying to develop a tool for taking inventory.  I have a
spreadsheet with three columns - QTY, ITEM#, DESC.  The sheet lists
the items#'s of every item and their description.  The QTY column is
blank.  When I scan a barcode, I want it to find the item# and then

We have created a form in excel for tracking false trips.
Is there anyway that when the user gets to the end of the form and presses
enter, that excel will then add in page 2, using the form format from page
one?

This group provided a pair of very quick and neat solutions to the splitting
of an address, i,.e  123 Adams St.  the 123 in one cell and the Adams St in
another.   (Currently using the first posted solution).
Some of my addresses now fell into the PO BOX and  APO formats.  In ...

Someone can help me on this error to 0
So I have a little sub that copy several times the same sheet (Sheet 2
--> Template) according to the number of name in the rngRange (range)
in sheet1

I have just installed Microsoft Office 2007 and am very disappointed because
whenever I attempt to enter the "properties" section of Excel, I receive the
message:
"Document Information Panel was unable to load."

I have two worksheets, one called schedule, one called sort.  I post this
question earlier and some folks are coming up with good help, but the help
stopped short.
The schedule worksheet look like this.

Is there any way to point the data source block to a cell.
I want to simply update a cell (i.e. A1) with the range instead having
to open the pivot table and changing from the wizard. Is there a way
to do this?

I have a spreadsheet that I have copied from Excel and pasted into Word 2007.
The document looks good on the screen but once I print out the document I
get a solid black box over the spreadsheet I copied.  
Please help

I need to convert data for the three columns below by repeating these steps.
Insert blank row at A1
Move contents of C2 to A1
Make A1 bold and underlined.

This may be a total misuse of Excel's capabilities, but . . .
I keep a small database of local residents, one attribute of which is
home state. When the home state is a province of Canada, I had been
putting a small Canadian flag over it.