Whew - this one has really got the better of me. I'm not used to using
dates in Excel and I just can't figure this one out by myself. Here's
what I'm trying to do:
Column A = list of months (across several years)

i need to find a way to permute my data in an excel sheet.
I have 5 different group of data which i need to permute with.
for example
rate    diame        material          surface      schedule

I have an Excel database that is linked to about 400 workbooks that
are contained in bout 35 different folders.  The database and all of
the folders containing the linked files are contained in a single
folder.

I am creating a document transmittal form that will show all revisions of a
document.
The range that the revisions are shown for a document is say M21 to Y21.
The revisions are entered starting at M21 and moving to the right in dated

Spreadsheet keeps track of date entries as tasks are completed for an
activity in a row.
Looking for a formula to put in a column to check to make sure dates
entered are  in chronological order.

I'm getting too many results when I try to find this myself.  Can someone
tell me the date that is associated with the 2002 version of Excel.exe?
Thanks!  I use 2007 so can't tell by the file on my computer but am trying
to help someone who uses 2002.

=VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
no in formation is entered in A19 it remains blank. I am currently getting
#na.

I am having problems with my current software for burning files onto CDs.
Which of the available software is considered the best for this purpose? OS
Win.Vista Business.

Hi to All,
I have a time and event tracking workbook in which math and db
functions are used to produce various timing and activity statistics.
For convenience I would like to enter times without typing the colon

I'm running Excel 2003, Sp2.
I'm using conditional formatting to change the background color on some
worksheet cells:
Cellvalue = Color

I do the formula =SUM(E9:E24) and I get ##### in my cell.  I put the curser
on it and it shows the number in a balloon but not in the cell and it messes
my final totals.  Why does it happen, and how do I fix it?

    I teach elementary computers, and I often make my own online worksheets
for the kids.  I am making an "ABC Order" sheet where I have pictures of
animals in one column and pictures of animal names (as opposed to just
typing the names in the cells) in another column.  The kids ...

My boss has a workbook that he has added columns and rows to. He gets sent an
updated version every couple of months from someone else. But the updated
version does not have his added columns and rows. Can we merge the workbooks
and be able to keep his added columns and rows to ...

How can I delete cells, (note not the content of these cells, but the cells
themselves) within a list that contain a specific value '0' without changing
the order of the remaining items in the list?

Is there an easy way to copy this to about 700 cells?
=SUMPRODUCT((A4:A11998=S6)*(B4:B11998=V3))
there has to be an easier way to copy this.